ok, post another book..
With smaller sample set, about 20 rows..

And This time write in a cell the count you expect.
And highlight ALL ROWS that you say are included in that count, and explain WHY each row is included or excluded from the count.


It may be important to note that the formulas we are providing are counting how many ROWS meet ALL 3 of your criteria.
Not how many individual cells meet each individual criteria.