| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help simple SUM
ok, i have multiple columns. i want to sum each column at row 4 w/o having to
type =SUM(A1:A3) then =SUM(B1:B3) and so on to column AC is there a way? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help simple SUM
1. Type the first formula (in A4).
2. Grab the fill handle (the small black square in the lower right corner). 3. Drag it across to column AC. 4. Release the mouse button 5. Voila, all your formulas will be populated. Regards, Fred "jmfozzybear" wrote in message ... ok, i have multiple columns. i want to sum each column at row 4 w/o having to type =SUM(A1:A3) then =SUM(B1:B3) and so on to column AC is there a way? thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help simple SUM
--Enter the 1st formula in cell A4.
--Copy the cell and paste the formula aross OR Use the selectio handle (select A4 move your cursor to the bottom right of cell A4; the cursor will change to cross). Click and drag the formula across..Excel will change the reference automatically If this post helps click Yes --------------- Jacob Skaria "jmfozzybear" wrote: ok, i have multiple columns. i want to sum each column at row 4 w/o having to type =SUM(A1:A3) then =SUM(B1:B3) and so on to column AC is there a way? thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help simple SUM
THANKS!!
"Jacob Skaria" wrote: --Enter the 1st formula in cell A4. --Copy the cell and paste the formula aross OR Use the selectio handle (select A4 move your cursor to the bottom right of cell A4; the cursor will change to cross). Click and drag the formula across..Excel will change the reference automatically If this post helps click Yes --------------- Jacob Skaria "jmfozzybear" wrote: ok, i have multiple columns. i want to sum each column at row 4 w/o having to type =SUM(A1:A3) then =SUM(B1:B3) and so on to column AC is there a way? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
Linear Mode
