Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT Formula Error, please help... ;o(
I have a large range Feb 2-27'!G7:N61 on worksheet 1 that includes monitoring
scores... Then I have a 2nd worksheet that I choose from a dropdown the Super's Name CELL "E2"... On the 2nd Worksheet I have other cell's formulas based on Cell "E2" selection that gives me the "Total Agents", "Total Evaluations", and "Overall Score Avg" for the Supervisor in "E2" Cell... But I can't seem to get the total Number of Scores over "=90" , and then another cell that will include the total number of Scores that are "<90".... here's what I attempted for the 2 formulas =SUMPRODUCT(('Feb 2-27'!$A$7:$A$61=E2)*('Feb 2-27'!$G$7:$N$61=90) and =SUMPRODUCT(('Feb 2-27'!$A$7:$A$61=E2)*('Feb 2-27'!$G$7:$N$61<90) Any assistance would be greatly appreciated... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT Formula Error, please help... ;o(
See your other post. Please don't multi-post.
Regards, Fred. "TxBlueEyes" wrote in message ... I have a large range Feb 2-27'!G7:N61 on worksheet 1 that includes monitoring scores... Then I have a 2nd worksheet that I choose from a dropdown the Super's Name CELL "E2"... On the 2nd Worksheet I have other cell's formulas based on Cell "E2" selection that gives me the "Total Agents", "Total Evaluations", and "Overall Score Avg" for the Supervisor in "E2" Cell... But I can't seem to get the total Number of Scores over "=90" , and then another cell that will include the total number of Scores that are "<90".... here's what I attempted for the 2 formulas =SUMPRODUCT(('Feb 2-27'!$A$7:$A$61=E2)*('Feb 2-27'!$G$7:$N$61=90) and =SUMPRODUCT(('Feb 2-27'!$A$7:$A$61=E2)*('Feb 2-27'!$G$7:$N$61<90) Any assistance would be greatly appreciated... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct returns value error when ref is formula | Excel Discussion (Misc queries) | |||
SUMPRODUCT formula returning #VALUE! error | Excel Worksheet Functions | |||
DIV/0! error in SumProduct formula with no division | Excel Worksheet Functions | |||
Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
SumProduct Formula Error | Excel Worksheet Functions |