Help with Count, three variables

[Hannainnc]

Hi everyone. I have a feeling that this is probably really simple, but I can't seem to figure it out. Hopefully you all will have the answer to my dilemma.

All I want to do is do a COUNTIF, but I need to get a count if it meets three criteria, all from the same row. I did have =COUNTIF($G:$G,"SNGL")
and this worked for me, but now I need to also include in this count cells with SNGL, CBSG, and SBSG. I tried entering the three in my formula and got an error message saying I have too many variables.

Thanks in advance for your help.

Hanna

 

[Oaktree]

Welcome to the board!

Do you want to count if it is ANY of those three? Or ALL of those three?

for the first, =COUNTIF($G:$G,"SNGL") + COUNTIF($G:$G,"CBSG") + COUNTIF($G:$G,"SBSG")

For the second,
=sumproduct(--(A1:A10 = "SNGL"),--(B1:B10 = "CBSG"), --(C1:C10 = "SBSG"))

 

[Brian from Maui]

Hi everyone. I have a feeling that this is probably really simple, but I can't seem to figure it out. Hopefully you all will have the answer to my dilemma.

All I want to do is do a COUNTIF, but I need to get a count if it meets three criteria, all from the same row. I did have =COUNTIF($G:$G,"SNGL")
and this worked for me, but now I need to also include in this count cells with SNGL, CBSG, and SBSG. I tried entering the three in my formula and got an error message saying I have too many variables.

Thanks in advance for your help.

Hanna

Try,

=SUMPRODUCT(--(ISNUMBER(MATCH(G1:G100,A1:A3,0))))

Where A1:A3 house the criterias and no whole column references

Edit,

After reading you question again, do you want OR'ing or AND'ing? You say row, as in A1:K1 or columns A1:A10?

 

[Hannainnc]

Oops..I am such a noob. I meant all from the same column, not row. I'll get that lingo down soon...I hope.

I need count of OR and I used the first method and it worked. Thank you so much.

Have a great weekend everyone!