how to write COUNTIFS in filtered table for shown data

hey guys,

in attached file, "Fixture" sheet, you ll see results of the league this season.

1- I filtered A column in "Fixture" sheet, HT Total Goals "0"
2- Then I go to "Teams" sheet and I want to write a statistic formula for team "Alessandria" for second half total goals ("Fixture" sheet C column ) Over 1.5 / Under 1.5

HT Total Goals : 0
Home Team: Alessandria
2H Total Goals over 1.5 ("Teams" sheet F3) should be 3
2H Total Goals under 1.5 ("Teams" sheet G3) should be 1

so in "Teams" sheet, how can I write the formula for team Alessandria in F3 and G3 cells ?

avk, thanks for help but,

why can't I write a formula which shows this data automatically which I filter any HT result in fixture sheet?
ur solution eleminates table function in fixture sheet

i couldnt explain good i think
i ll try to explain with screenshots

pls check these files.

i mean that u need to write a code to check one criteria for the shown data in "Fixture" sheet. (2nd half total goals over 1.5 or under 1.5)
but in ur previous codes, u writing all criterias in ur code. ( home team, first half total goals, 2nd half total goals)
then why i should make a table for data?

i wanna filter criterias how i wish from table in "Fixture" sheet manually, and write a code for one criteria and check that criteria for "ONLY SEEN DATA".
bcuz ur previous codes always checking both seen and unseen data in Fixture sheet.
i wanna check only seen data after my filters.