Excel formulas that repeat
Yes there is:
=SUM(A1:A8;C1:C5)
Here you have the sum of a1 to a8 and c1 to c5.
You can use the CTRL button to select the next section of cells.
"hhspotts" wrote:
I have a table in which I want the total (SUM) of each column--is there a
shortcut to inserting the formulas or do I have to do =SUM(A1:A4),
=SUM(B1:B4), =SUM(C1:C4) etc.?
hhspotts
|