Ok this seemed easy until it didn't work. :/
I have a column with numbers varying in values. I need to count the numbers that are greater, equal or less then specific numbers like "<=1" this one was easy. However when I try ">=2,<5" that doesn't work with count it. I could use sumproduct but I have other criteria I am checking.
=COUNTIFS(general_report!O2:O281,">=2,<5",general_report!A2:A281,"=Incident", general_report!F2:F281,"=P1")
How can I count the number between but look for the two criteria as well?
=SUMPRODUCT((O2:O281>=0)*(O2:O281<=1))
=SUMPRODUCT((O2:O281>=2)*(O2:O281<=5))
but that will grab everything and not look at other criteria "=Incident" and "=P1" like I need it to. Is there a way to work around this?
Thanks!
Bookmarks