• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Embarrassing, but I need help with COUNTIF with muptiple conditions


New Member
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?