Are you sure that it shouldn't be separate functions

=SUMPRODUCT((Mark!X9:X258=Info!B15)*(Mark!F9:F258= Mark!Y9)*(Mark!F9:F258=Mark!Y10))
+SUMPRODUCT(Craig!X9:X258=Info!B15)*(Craig!F9:F258 =Craig!Y9)*(Craig!F9:F258=Craig!Y10))
+SUMPRODUCT(Dan!X9:X258=Info!B15)*(Dan!F9:F258=Dan !Y9)*(Dan!F9:F258=Dan!Y10))

--
__________________________________
HTH

Bob

"Dianna_P" wrote in message
...
I want to count cells from 3 worksheets that meet multiple criteria.

I've tried with a result of 0 (it should be 3):

=SUMPRODUCT((Mark!X9:X258=Info!B15)*(Mark!F9:F258= Mark!Y9)*(Mark!F9:F258=Mark!Y10)*(Craig!X9:X258=In fo!B15)*(Craig!F9:F258=Craig!Y9)*(Craig!F9:F258=Cr aig!Y10)*(Dan!X9:X258=Info!B15)*(Dan!F9:F258=Dan!Y 9)*(Dan!F9:F258=Dan!Y10)

I've also tried with a result of 0:

=SUMPRODUCT(--(Mark!X9:X258=Info!B15),--(Mark!F9:F258=Mark!Y9),--(Mark!F9:F258=Mark!Y10),--(Craig!X9:X258=Info!B15),--(Craig!F9:F258=Craig!Y9),--(Craig!F9:F258=Craig!Y10),--(Dan!X9:X258=Info!B15),--(Dan!F9:F258=Dan!Y9),--(Dan!F9:F258=Dan!Y10)

Please help!