SUMPRODUCT Fomula, I must be missing something... Help!

  • Thread starter Thread starter TxBlueEyes
  • Start date Start date
T

TxBlueEyes

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...
 
if you're trying to do this from within Excel, suggest you post to an Excel
newsgroup. this ng answers questions about creating reports in MS Access
relational database software.
 
Back
Top