Excel formulas that repeat

[hhspotts]

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

 

[Pete_UK]

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

 

[Kees Vos]

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.