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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can a cell be turned on or off? 1
Linking cell ranges between rows and columns 1
how to use if formula in list (data validation list) 1
Copy Excel functions formula and auto refresh refresh 3
How to concatenate many rows in Excel 2
Calculating column A * column B = Results in another column 2
relative offset to a named cell 3
Copying formulas across columns 2

Back
Top