I want a formula that will tell me how many 'Trues' I have, when Team = A
and league = 1 etc.

Team League ResultA
A 1 TRUE
B 1 TRUE
C 1 TRUE
A 2 TRUE
B 2 TRUE
C 2 FALSE
A 3 TRUE
B 3 TRUE
C 3 TRUE
A 1 TRUE
B 1 TRUE
C 1 FALSE
A 2 FALSE
B 2 FALSE
C 2 TRUE
A 3 FALSE
B 3 FALSE
C 3 FALSE