Countif multiple cells if cell 1 equals X

[argentraven]

I have a spreadsheet where C3 has a capital X as the text in it. Cells E3 through AF3 have a value in each of them ranging from 1 to 5. I want to calculate that if C3 has an X, then tell me how many 5's are there total in cells E3 through AF3. I know I can get the total number of 5's using =(COUNTIF(E3:AF3, "5")). but I'm stuck on qualifying it with if C3 has an X or not.

EDIT:

OK, so I think I figured it out. =IF(C3="X",(COUNTIF(E3:AF3, "5")))

However, IF the result is False (IE: no X, therefore no value) how do I get it to show zero?

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[argentraven]

Awesome!! Thank you!

[TMS]

You're welcome. Thanks for the rep.