Help with SUM command

[zutalors212]

Suppose that I have data in columns A1:A100 and B1:B100. I know that I
how to sum up the totals from A1:A100. It's simply "=SUM(A1:A100)" .
However, suppose that I want to divide this value by the sum of column
B. In effect, I would like to find the value of
SUM(A1:A100)/SUM(B1:B100) - How can this be accomplished in MS
Excel?

I am *NOT* interested in:
1. "=SUM(A1:A100)" entered in cell, C1, for example.
2. "=SUM(B1:B100)" entered in another cell, C2, for example.
3. In C3 typing in "=C1/C2".

I AM INTERESTED IN A "ONE STEP COMMAND" TO ACCOMPLISH THIS.

Thanks my friends.

 

[Beege]

Try
=SUM(A1:A100)/SUM(B1:B100)
Beege

 

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[zutalors212]

That was it.

Thanks!