Thanks for the help BoniM. It works great.

Dale

"BoniM" wrote:

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

"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