Sum the results of an equation through a series of Cells
 

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.

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.