Help with SUM command and division

  • Thread starter Thread starter Brablo
  • Start date Start date
B

Brablo

I have data in columns A and B from rows 1 to 100. I would like to do
the following in a one-step comman:
1. in C1:=Sum (a1:a100)
2. In column D1:D100=b1/a1, and then copy and paste this from d1:d100.

3. In E1:=SUM(d1:D100)
4. F1:=c1/e1

How do I do this in one step?
 
=SUM(A1:A100)/SUMPRODUCT(B1:B100/A1:A100)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 

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

Looping through permutations 7
How to set cell value to emptry if three other columns are empty too 1
Formulas 5
cells with one to multiple lines 1
Find the rightmost value 5
Use of sumproduct() in EXCEL 7
somewhat complicated conditional formula 2
Help in counting and summing cells based on multiple conditions 9

Back
Top