How to use multiple criteria in Google Sheets COUNTIFS function?

Other Questions Google Sheets
1

I’m having trouble with a COUNTIFS formula in Google Sheets. I want to count rows that match two different criteria in the same column. Here’s what I’ve tried:

=COUNTIFS(ResultsLog!C:C,A11,ResultsLog!F:F,"Win" & "MTT Cash")

This formula works fine when I only use “Win” as the criterion. But when I add “MTT Cash”, it always returns 0. I’m not sure what I’m doing wrong.

Does anyone know how to make COUNTIFS work with multiple criteria in the same column? I need to count rows that have either “Win” or “MTT Cash” in column F.

I’ve looked at the Sheets help docs but couldn’t figure it out. Any advice would be really helpful! Thanks in advance.

2

I’ve encountered this issue before, and there’s a simpler solution using the OR function within COUNTIFS. Try this formula:

=COUNTIFS(ResultsLog!C:C,A11,ResultsLog!F:F,“Win”)+COUNTIFS(ResultsLog!C:C,A11,ResultsLog!F:F,“MTT Cash”)

This approach counts rows that match the criteria in column C (A11) and have either “Win” or “MTT Cash” in column F. It’s more efficient than using multiple COUNTIFS functions, especially if you need to add more criteria later.

Remember, COUNTIFS is case-sensitive, so ensure your criteria match exactly what’s in your sheet. If you’re still having trouble, double-check for any hidden spaces or formatting issues in your data.

Let me know if this works for you or if you need further clarification.

3

hey Stella, ive got a trick for ya. instead of using & try this:

=COUNTIFS(ResultsLog!C:C,A11,ResultsLog!F:F,{“Win”,“MTT Cash”})

it lets u count multiple criteria in one go. no need for separate formulas or OR functions. give it a shot and lemme know if it works!

4

Hey there, I’ve wrestled with similar COUNTIFS challenges before. The trick is to use separate criteria within the same function. Here’s what worked for me:

=COUNTIFS(ResultsLog!C:C,A11,ResultsLog!F:F,“Win”)+COUNTIFS(ResultsLog!C:C,A11,ResultsLog!F:F,“MTT Cash”)

This essentially creates two separate counts and adds them together. Each COUNTIFS checks for your A11 criterion in column C, then looks for either “Win” or “MTT Cash” in column F.

If you need to add more criteria later, just keep chaining them with plus signs. It’s not the most elegant solution, but it gets the job done without needing array formulas or complex setups.

Hope this helps solve your counting conundrum!