Using Multiple Conditions in Google Sheets

Other Questions Google Sheets
1

I am attempting to calculate counts for both ‘Win’ and ‘MTT Cash’ results simultaneously. Here is my formula: 

=COUNTIFS(ResultsLog!C:C, A11, ResultsLog!F:F, ‘Win’ + ‘MTT Cash’)
This works correctly for just determining the count of ‘Win’, but when I try to include +‘MTT Cash’, it returns 0. Any assistance would be greatly appreciated!

2

Try using QUERY function for this. It can be quite powerful & flexible. Here’s a quick example:

=COUNT(QUERY(ResultsLog!A:Z, "select F where C = '"&A11&"' and (F='Win' or F='MTT Cash')", 0))

This way, you get to combine data from different conditions seamlessly. cheers!

3

Hey FlyingLeaf, try using the formula =SUM(COUNTIFS(ResultsLog!C:C, A11, ResultsLog!F:F, “Win”), COUNTIFS(ResultsLog!C:C, A11, ResultsLog!F:F, “MTT Cash”)). This will add counts for ‘Win’ and ‘MTT Cash’ separately so both get included. hope it helps!

4

Rather than combining conditions in the COUNTIFS function, use a SUMPRODUCT approach, which can be more flexible when handling multiple conditions. The SUMPRODUCT function can evaluate criteria over arrays more effectively. For this use case, try the following formula:

=SUMPRODUCT((ResultsLog!C:C = A11) * ((ResultsLog!F:F = "Win") + (ResultsLog!F:F = "MTT Cash")))

This formula will count occurrences where the results in column F are either ‘Win’ or ‘MTT Cash’ while matching column C with A11, effectively handling the multiple conditions.

5

I encountered a similar issue in the past, and one alternative approach is using the FILTER function combined with COUNTA. Essentially, you can filter the relevant rows by the matching criteria and then count the results. Here’s how you can do it:

=COUNTA(FILTER(ResultsLog!F:F, (ResultsLog!C:C = A11) * ((ResultsLog!F:F = "Win") + (ResultsLog!F:F = "MTT Cash"))))

This filters the data based on your criteria and counts only the filtered entries, making it a versatile solution for managing multiple conditions. It’s especially helpful when working with large datasets, as FILTER can be more efficient than COUNTIFS for complex scenarios.