Sumproduct to SumDivide ?????????

[Guest]

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

 

[Guest]

Just create a matrix with value running along the horizontal axis and life
running along the vertical, and divide the x,y values at each intersection.

Then you have a matrix of various annual costs for various life times.

I don't really think you can think of your "sum divide" as the inverse of
sumproduct.

Dave

 

[Guest]

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

 

[Guest]

Of course, for your sample, you would be dividing column b by column a - my
sample showed the reverse.

 

[Guest]

Thanks for the help BoniM. It works great.

Dale

 

[Guest]

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