Hi, I was wondering if someone could help me out. I looking for a formula that will count wins and loses for a particular sport. I've attached a sample of my spreadsheet.
Ex. if B = NFL then F4 would count all the 'won' in column C and G4 would count all the 'Loss' in column C
if B = NBA then F5 would count all the 'won' in column C and G5 would count all the 'Loss' in column C
if B = NHL then F6 would count all the 'won' in column C and G6 would count all the 'Loss' in column C
etc
not sure if I explained my self correctly but any help would be appreciated.
Bookmarks