Embarrassing, but I need help with COUNTIF with muptiple conditions

[mvirgilio53]

I know there are literally dozens of pages about doing a countif with two conditions, but none of them work for me. I'm using excel 2003, so I can't us countifs. I need to count how many times the phrase "Total Operational" appears with a "0" in a column to the right of. I've tried the following:


SUM(IF(M:M="Total Operational",IF(R:R=0,1,0),0))

SUM((M:M,"Total Operational")*(R:R,0))

SUMPRODUCT((M:M,"Total Operational")*(R:R,=0))


And they all return a #NUM! error. Any suggestions?

 

[Hui]

Try

=+SUMPRODUCT(1*(M:M="Total Operational")*(R:R=0))

 

[mvirgilio53]

And I just realized I spelled multiple wrong. Thanks, I'll try in the morning.