| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel repeat formula ..??? | Excel Worksheet Functions | |||
| How do I repeat an item in multiple formulas w/out retyping each | Excel Worksheet Functions | |||
| How do I repeat formulas i.e. m2:x2 then m3:x3 without typing | Excel Discussion (Misc queries) | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
| Macro to repeat formulas in next row | Excel Discussion (Misc queries) | |||
Linear Mode
