Hello everyone...
My first post here so please be gentle....
I've read a few dozen threads and I've approached the vlookup, countif, if, sumproduct, and a handful of other strategies to no avail - I figure this is simple enough and I'm probably not doing it correctly but I'd love any help I can get. I've attached a file and I've detailed below what I'm trying to do....
So I've got a rather small table of data that serves as a schedule for a soccer league. I'm hoping to create an automated standings page that pulls wins and losses from the table. Easy enough - but the kicker is that there are multiple divisions, and some of the divisions have identically named teams...for example, the tigers might be a team in the boys division as well as a team in the girls division, but those wins and losses must be counted separately.
A simplified example of what I'd like to do is have a function that counts and displays the number of times that for every row where "girls" is in the division column AND "tigers" is in the winner column.
I don't know if this is a good explanation but I'm here ready to try and rearticulate! Thanks for your time!
Bookmarks