COUNTIF function

Hello!
I have some issues on my formula.. is giving me "#VALUE" and i can't figure it out the solution...
From the workbook example, in the right table i want a count function from a criteria like sumif function
Team A 2-1 Team B
I want for team A to count as 1 for "over or at least 3" in the table... the sum of the numbers... and under if the sum of the numbers result under 3
hope you guys understand. Thank you!

Hi,

I have attached the file with a quick and dirty solution with 2 additional columns.
Have a look, may be it helps for you.

Thank you for your helping, but i want the results to be the same with my workbook.. on over or at least are 0... and if is possible to not add anything, like IF function between data and table

Try

in J2

=SUMPRODUCT((($A$1:$A$2=$I2)+($E$1:$E$2=$I2))*($B$1:$B$2+$D$1:$D$2<3))

in K2

=SUMPRODUCT((($A$1:$A$2=$I2)+($E$1:$E$2=$I2))*($B$1:$B$2+$D$1:$D$2>=3))

Thank you, JohnTopley! Is working :-D