Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct W-t-d | Excel Worksheet Functions | |||
Sumproduct? | Excel Worksheet Functions | |||
Sumproduct? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Help | Excel Worksheet Functions | |||
SUMPRODUCT Help | Excel Worksheet Functions |