I figured it out and if I must say so myself...I am amaaaaaazing!!!

If anyone happens upon this thread...I solved the problem w the sumproduct function....since we're counting x dependent on y and z, you just need to turn y and z into a number - I originally wanted to approach this with the IF function but the key is that it needs to be able to use an array! Soooooo you plug in the double negative to your standings table to look something like this...


A, B, C
Blank Cell,Girls Division, Wins
Lions, =sumproduct(--(divisionarray=B1),--(winsarray=A2))