Excel formulas that repeat
 

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

Excel formulas that repeat
 

Put the first formula in A5, i.e.:

=SUM(A1:A4)

then copy that formula and paste into B5:E5, or whatever.

Hope this helps.

Pete


"hhspotts" wrote in message
...
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

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