SUMPRODUCT Formula I need help, Large Datasheet. help....

[TxBlueEyes]

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...

 

[Bob Phillips]

These work for me

=SUMPRODUCT(('Feb 2-27'!$A$7:$A$61=E2)*('Feb 2-27'!$G$7:$N$61>=90))

=SUMPRODUCT(('Feb 2-27'!$A$7:$A$61=E2)*('Feb 2-27'!$G$7:$N$61<90)*('Feb
2-27'!$G$7:$N$61<>""))

 

[Shane Devenshire]

Hi,

See your other post for a solution and try not to double post. I know we
all want instant response and instant displays of our posts but it doesn't
always happen.