Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
series graph -- one series being added to another series | Charts and Charting in Excel | |||
Dynamic series in Chart | Charts and Charting in Excel | |||
Equation giving unexpected results | Charts and Charting in Excel |