Formula to Calculate Win/Loss Records from Sheet 1 to Sheet 2 After Filtering Data

I have 2 sheets in the attached workbook. The main data comes into the "Game Log" sheet. The only columns that I am focused on are column B "TM" (Team Name) and column K "R" (Runs) I have a formula on the Game Log sheet in cells Y1:AF1 that will calculate wins and losses for everything in column B as I manually filter column B, and If the number in column K is 0, this is counted as a Win, if the number in column K is 1+ it is counted as a Loss.

What I would love to do is have a formula in the Win-Loss Tracker sheet that can find the value of the corresponding team in column B of the Game Log Sheet and count how many cells are "0" in column K and how many cells are 1+ in column K of that game log sheet. and have this formula applied for each team in the win-loss tracker sheet.

For example, the first team listed on the Win-Loss Tracker is "ARI" I would like to have a formula for D3 ("Wins") in the win-loss tracker sheet that will look for the name "ARI" in column B of the game log sheet and for those values, have it automatically calculate how many cells in column K have a "0" to count these as wins. Then for cell E3, it would do the exact same thing, however, it would automatically count any value 1 or higher in column K.

The idea here is to have the data automatically update for each individual team instead of manually going through every filter and inputting by hand.

Is this something that would be possible?

Thank you for the quick response, however, Z2 is showing a value of 56, but if it is sorting for the number of cells containing "0" in column K, it should equal 138. I would assume if I can get this formula figured out, I can apply the same one for any value in column K that is >=1 as well.

This way it will automatically calculate the Wins (0) and Losses (1+) and these formulas can then be copied for each team.

Thank you!

There is a formula in Z1 for the wins and AB1 for the losses for reference. (for a win, K2:K50000=0 and for a loss, K2:K50000>=1)

These are the results I am looking for, but with a way for it to automatically apply to the specific value in Column B vs calculating for a total count of every team name listed in column B.

For "ARI" the formula would count all of the 0's in column K and this total would populate in cell Z2, and a similar formula counting everything above 0 would populate in cell AB2 as a loss.

With the data that is in there, Z2 should be populating "138" and AB2 should be populating "32"

Yes, that is perfect. Thank you so much! You are amazing!