Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Guys,
I have a question regarding the sumproduct formula. Here is the situation; considering the following data set; $0.00 (D66) $0.00 (D67) $14.00 $18.75 $18.25 $20.00 $20.00 (D72) I am computing the adjusted average for the above data set discounting zeros and the max outlier. My formula is SUMPRODUCT((D66:D720)*(D66:D72<MAX(D66:D72))*D66: D72)/SUMPRODUCT((D66:D720)*(D66:D72<MAX(D66:D72))) In the situation described above, it must take 14 as the outlier and discard as that is more qualitatively appropriate. So my question is, can the sumproduct check for the max and min outlier, discard whichever is farthest from the simple average (simple average too discards zeros), discard zeros, and then give me the adjusted average??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SumProduct Question | Excel Discussion (Misc queries) | |||
SumProduct Question | Excel Discussion (Misc queries) | |||
Sumproduct question | Excel Discussion (Misc queries) | |||
Sumproduct Question | Excel Worksheet Functions | |||
Sumproduct ?? Question | Excel Worksheet Functions |