Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGE & SUMPRODUCT
I'm trying to calculate an average of a series of numbers, which
numbers are within a range. Not all members of the range should be included in the average calculation, however. I have the following: =SUMPRODUCT(--(K2:K13="WMT"),(M2:M13))/COUNTIF(K2:K13,"WMT") which obviously works but it would seem to me there is a more direct way to do this using the AVERAGE function. (I'm using SUMPRODUCT here instead of SUMIF because I may need to add conditions in the future.) Thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average nesting within Sumproduct? | Excel Worksheet Functions | |||
sumproduct and average functions | Excel Worksheet Functions | |||
Using Sumproduct to Find Average | Excel Discussion (Misc queries) | |||
Sumproduct Average | Excel Discussion (Misc queries) | |||
sumproduct & average | Excel Worksheet Functions |