formulas for totaling rows

B

Brian

=B1+C1 To Cell D
=B2+C2 To Cell D
=B3+C3 To Cell D
Repeat this formula without having to enter it in each cel

the take D1 and devide by A1 and repeat for each cell.
 
F

Frank Kabel

Hi Brian
just enter the first formula and copy this for all rows. The reference
will change automatically
same is true for your other formula. enter
=D1/A1
in the first target cell and copy down
 
Top