Forum Discussion
COUNTIFS help for and or criteria
Please help - I keep getting error/spill or n/a error messages. I have columns E7:G128 on SLD page that may contain the word Below In column D7:D128 on SLD page I have the class numbers 3-18 Tryi...
The ranges in COUNTIFS must have the same shape and size.
Try
=SUMPRODUCT((ISNUMBER(SEARCH("Below",SLD!E7:G128))*ISNUMBER(SEARCH("3",SLD!D7:D128))))+SUMPRODUCT((ISNUMBER(SEARCH("Below",SLD!E7:G128))*ISNUMBER(SEARCH("4",SLD!D7:D128))))