Multiple Count If Formula

[Perch]

Hi
I have a multiple COUNTIF ( or something else) problem enclosed
I need to count the items that fall within multiple criteria just for one SEASON when original list of data is across many seasons
Hope enclosed file is self explanatory

many thanks
Peter

[oeldere]

with Vlookup in a table.

after that a pivot table.

see the attached file.

[Special-K]

in I4
=SUMPRODUCT(($C$3:$C$16=$H4)*($D$3:$D$16="SS16")*($E$3:$E$16=0))
in J4
=SUMPRODUCT(($C$3:$C$16=$H4)*($D$3:$D$16="SS16")*($E$3:$E$16<=0.3))
in K4
=SUMPRODUCT(($C$3:$C$16=$H4)*($D$3:$D$16="SS16")*($E$3:$E$16<=0.4))
in L4
=SUMPRODUCT(($C$3:$C$16=$H4)*($D$3:$D$16="SS16")*($E$3:$E$16<=0.5))
in M4
=SUMPRODUCT(($C$3:$C$16=$H4)*($D$3:$D$16="SS16")*($E$3:$E$16>0.5))
copy row I4:M4 to row 5

[JeteMc]

Here is another formula solution alternative. For column I*:

Please Login or Register  to view this content.

For columns J:L

Please Login or Register  to view this content.

For column M

Please Login or Register  to view this content.

*If I3 read " 0% Mark Down" (Notice a space to the left of the zero) you could use the same formula as with columns J:L
Attachment has formulas applied.
Let me know if you have any questions.