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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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