The attached Excel File contains team stats for specific Teams.
I'd like to be able to type a team in D1, G1, J1 and M1 and automatically calculate the number of wins losses for that team only.
For instance, If 'TOR' is typed in D1 then
B1 should contain all the times BAL (B4) won versus TOR (D1) While Cell
C1 should contain all the times BAL (B4) lost versus TOR (D1).
Ditto for the rest of the teams.
The Data in rows 3 and 4 calculate based on specific cell ranges.
Keep in mind that team data can be updated to include more data on the bottom most cells.