Countif A condition is met

It appears that the team names are in Weekly Stats::Table 1::I and the Win true/false is Weekly Stats::Table 1::U. I do not see where any team names are in your summary table nor do I know what column is the count of wins for each team. I will say the team names are in column A and the count of wins (where the formula needs to be) is in B

Column B formula in the summary table =COUNTIFS(Weekly Stats::Table 1::I,A,Weekly Stats::Table 1::U, TRUE)

This says to count the instances where the team name in Weekly Stats::Table 1::I is the same as the team name in Summary::A (the cell on the same row as the formula) AND the value in Weekly Stats::Table 1::U is TRUE.

Looking back at it after seeing more of your table and finally getting what was going on, your original COUNTIF(Weekly Stats::Table 1::G07:DO7, "TRUE") formula should work if the Win columns are the only ones with "TRUE" in them and they have the string "TRUE" not the boolean value TRUE. Given that it works with "yes", it leads me to believe the Win columns have the boolean value TRUE while your formula is checking for "TRUE". However, my formula checked for the boolean value TRUE, unless you changed it to "TRUE", so I am perplexed.

Still, it is better to use COUNTIFS and check only those columns that are the Win columns.

The format for COUNTIFS is COUNTIFS(range, condition, range, condition,...) and it will count the instances where ALL the conditions are met. You have written it as COUNTIFS(range,range,range....., condition).

If the teams are listed in the same order in the Summary table as they are in Weekly Stats (so we do not have to find which row in Weekly Stats has that team), the formula below should work for the Patriots, then drag-fill down to do the rest of them

=COUNTIFS(Weekly Stats::Table 1::5:5,TRUE,Weekly Stats::Table 1::$4:$4,"Win")

It counts all the TRUEs on row 5 that also have "Win" in row 4.

I have to admit I am totally perplexed by the formula you posted in your screenshots. The outside parentheses are unnecessary, the SUM is doing nothing and is also unnecessary, and I am sorry to say the COUNTIFS part of it makes no sense with all the cell references from the same row. I am ignoring it completely. Because you do need to use the COUNTIFS formula to get your results, you really should read up on it.

EDIT (deleted the formula): The formula I posted was incorrect. I need to see all the columns of the weekly stats table. I see now that there are multiple games on each row. Your first screenshot showed games 2 and 3 (though all the info for game 3 was covered up). The second one shows games 1 and 2. I cannot write a formula without seeing all the columns (all games) and the column letters.