formulas for totaling rows

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

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
Copy Excel functions formula and auto refresh refresh 3
how to use if formula in list (data validation list) 1
Cell entry 2
How to concatenate many rows in Excel 2
Repeat formula for all cells in whole column 1
relative offset to a named cell 3

Top