View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kees Vos[_2_] Kees Vos[_2_] is offline
external usenet poster
 
Posts: 9
Default 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