help simple SUM

  • Thread starter Thread starter jmfozzybear
  • Start date Start date
J

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

Jacob Skaria said:
--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
Click to expand...
 
Back
Top