Hi Dale,
Yes, you can definitely use a formula to divide the value by the lifetime of the object to get the annual cost. Instead of using the
SUMPRODUCT function, you can use the
SUM function along with the
DIVIDE function (which is represented by the forward slash "/").
Here's an example formula you can use:
- =SUM(B2:B10/D2:D10)
In this formula,
B2:B10 represents the range of values and
D2:D10 represents the range of lifetimes. The formula will divide each value in column B by its corresponding lifetime in column D, and then sum up the results to give you the total annual cost of the equipment.
You can adjust the ranges in the formula to match the actual range of data in your worksheet.
Note: If there is any
macro or
Visual Basic code, wrap it in the tags.