I'm very new to Google Sheets.
I have a sheet where I record the outcomes of games played.
- Each row represents a single game
- Column A,
Map, stores the name of the map that was played.
- Column D,
Result, contains either Win, Loss, or Tie.
Count by Result
I created a formula using COUNTIF that returns the total count based on the
Result (outcome) entered in the cell above it.
- formula is in
G2and was also copied to
Count by Result and by Map
Similar to my formula above, I'd like to return the total count but by
Map. For example, if the
Map is Mirage then the total wins, losses, and ties across all games played on the Mirage map only.
How can I do that?