Wow! I didn't know that. After reading your post I found I could
"SumExponentiate" also -- cool!



"BoniM" wrote:

sumproduct still works - use the division operator between ranges:
=SUMPRODUCT((A2:A10)/(B2:B10))


"Dale" wrote:

I am familiar with the sumproduct function when calculating a range of data
but I was wondering if I could sum divide. I have following example:

Column A is lifetime of an object, say 1.5 years
Column B is the value of that product, say $10,000
I want to divide $10,000 by the 1.5 years so I will know the annual "cost"
of the good. I want to determine this for a list of different lifetimes and
values to determine the annual "cost" of the equipmnet.

I was wondering is there a quick way to do this or should I just add a
column for the division function and sum that column?

Thanks

Dale