formulas for totaling rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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.
 
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
 
Back
Top