What is stopping you dragging the fill handle of that cell down the column
to copy the formula?
Is it that some cell references should remain unchanged?
=(((A5*100)+26.6)*(B5*2))+(((A5*100)+64)*($J$5*2))
will keep J2 unchanged
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"AZ" wrote in message
...
I'll explain this the best I can and hopefully some kind soul can help me.

Here is my base equation:
=(((A5*100)+26.6)*(B5*2))+(((A5*100)+64)*(J5*2))

What I would like to do is repeat this equation through the 23rd row and
generate a sum of the results.

I think an array formula might do the trick, but I have been unsuccessful
at
getting it to work. Any suggestions anyone can provide will be greatly
appreciated.

Thank you.