help simple SUM

[jmfozzybear]

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

 

[Fred Smith]

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

 

[Jacob Skaria]

--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

 

[jmfozzybear]

THANKS!!

--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