You can use this array* formula in I3, based on your CF condition for green:
=SUM(IF(($A$3:$G$16>=$M$1)*($A$3:$G$16<=$M$2),0,1))
*Note that an array formula needs to be confirmed using the key combination of Ctrl-Shift-Enter, instead of the usual Enter.
It gives a result of 66.
Hope this helps.
Pete
EDIT: You may need to use semicolons ( ; ) instead of commas ( , ), depending on your regional settings.
Bookmarks