I am not sure I have the concept(s). Please check the attached.
For the column I comparisons I have copied column A, pasted into column P and removed duplicates. The <358,9 and >298,9 criteria are in Q1:R1. Then this formula in Q2 filled down and across. There are numbers > 0 returned in column Q but not in column R.
Formula:
=COUNTIFS($A:$A,P2,$I:$I,Q$1)
In columns T:V the setup is the same. Attempted to do comparisons for G:H respectively. I suspect this one is wrong, but please have a look and give me guidance. In U2 filled down and across.
Formula:
=COUNTIFS($A:$A,T2,G:G,U$1)
Bookmarks