COUNTIFS question

Question

Hi, I am trying to count two different text options in a range of cells. So my cells are either blank, or have a X, H or S. How do i count just the cells that have H or S in them? Thanks in advance.

Answer 1

Dear respected Matthew Crump1,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, I assuming your range is A1:A10, you can use the following formula:

=COUNTIF(A1:A10, "H") + COUNTIF(A1:A10, "S")

If there is any misunderstanding, I apologize and for better understanding and guiding you further, could you please send copy of your document file to me so that I can look from my side, and I will check this behavior and help you to fix and verify the result with you.

If there is confidential information, then you can send it to me in Private Message(PM). you can access PM from the top right corner of this page, as shown in image below:

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 2

You can use something like:

=SUM(COUNTIF(A:A,{"H","S"}))

adjusting the A:A part to whatever your range is.