Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT to average
I have a SUMPRODUCT for numbered data, but also require it for % data. My
SUMPRODUCT is: =SUMPRODUCT(--(Sheet2!B4:B573=A6),(Sheet2!C4:C573)) This provides a total % figure of 475%, but I want the average of the 5 figures selected (it could be as many as 1-5 figures) - is this possible with the SUMPRODUCT formula. Thanks for looking |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE & SUMPRODUCT | Excel Discussion (Misc queries) | |||
Average nesting within Sumproduct? | Excel Worksheet Functions | |||
Using Sumproduct to Find Average | Excel Discussion (Misc queries) | |||
Sumproduct Average | Excel Discussion (Misc queries) | |||
sumproduct & average | Excel Worksheet Functions |