•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Im having troubles with using count functions
Our take
If you're navigating the complexities of counting functions in spreadsheets, you're not alone. Many users encounter challenges when attempting to count occurrences based on multiple criteria, especially when dealing with different ranges. In your case, where player names and outcomes are spread across different rows, using a combination of the `COUNTIFS` function or exploring `SUMPRODUCT` may provide the solution you need.
I have a question, i couldnt find answer on internet. How and what function to use to count with multiple criterias but criteria ranges are different, rows are different to be precise. For example in 3 rows i have 3 players who played that day (one below other, 1st, 2nd and 3rd row) and in 4th row i have "win" or "loss". So i wanna use function if i can, to count how many times one particular player played and in same week they won ? And to be clear there are 30+ players and they are changing from day to day.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience