1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Im having troubles with using count functions

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.

submitted by /u/djape_ds
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#row zero
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#count functions
#multiple criteria
#criteria ranges
#players
#row
#win
#loss
#function
#counting
#same week
#played
#changing