u/djape_ds

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.