Help with SUM command and division

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?
 
B

Bob Phillips

=SUM(A1:A100)/SUMPRODUCT(B1:B100/A1:A100)

--

HTH

Bob Phillips

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