Forum Discussion
Solved
I am trying to create a formula to calculate home and away games using two criteria.
I am trying to create a formula using multiple criteria. I am trying to match two criteria Column C (date) and column F (Home="" Away=@) There are multiple occurrences for each match. For excample, c...
Away games:
=COUNT(UNIQUE(FILTER(C3:C26,F3:F26="@")))
Home games:
=COUNT(UNIQUE(FILTER(C3:C26,F3:F26="")))
If you have access to FILTER and UNIQUE you can apply these formulas.
Away games:
=COUNT(UNIQUE(FILTER(C3:C26,F3:F26="@")))
Home games:
=COUNT(UNIQUE(FILTER(C3:C26,F3:F26="")))
If you have access to FILTER and UNIQUE you can apply these formulas.
- Yesssssss!!! Thank you Oliver, I almost had it lol. I think I left off the filter function. You Rock!!