In cells E1 through E940 are the values. In cells F2 through F941 are where I am trying to place formulas that add the values from Row 1 to the corresponding row where the calculation is taking place.
In Cell F2 I have: =SUM(E1:E2)
In Cell F3 I have: =SUM(E1:E3)
In Cell F4 I have: =SUM(E1:E4) and so forth.
Is there a formula that I can enter in F2 that can be copied and pasted from F3 through F941 which will speed up the construction of my spreadsheet? Thank you in advance.
2006-12-27 20:45:27 · 3 answers · asked by Awesome Bill 7 in Computers & Internet ➔ Other - Computers
Try:
=sum(E$1:E2)
And when you copy that, the dollar sign will maintain that cell as fixed, while the cell without the dollar sign will still shift according to the row it is copied to.
2006-12-27 21:03:07 · answer #1 · answered by AsiaWired 4 · 1⤊ 0⤋
In Cell F2 you have: =SUM(E1:E2)
In Cell F3 you have: =SUM(E1:E3)
In Cell F4 you have: =SUM(E1:E4)
In Cell F5 you have: (ALLEZ LES BLUES)
2006-12-28 08:21:53 · answer #2 · answered by tουΖουrs 3 · 0⤊ 1⤋
insert a column between the two that has a subtotal and you just add the next figure to the subtotal to get the grand total
2006-12-28 04:55:33 · answer #3 · answered by cool_clearwater 6 · 0⤊ 0⤋