Forum Discussion
=COUNTIF with both AND and OR functions
How can I count multiple criteria from multiple columns but one of the columns can be any of several values? I'm trying to count the reason for Non-diagnostic specimens defined within a final di...
I'd use a finite range for the following.
=SUMPRODUCT(($F$1:$F$500=B1)*($D$1:$D$500=A5)*((ISNUMBER(SEARCH("Hypocellular", $K$1:$K$500))+ISNUMBER(SEARCH("insufficient", $K$1:$K$500)))>0))
Adjust the ranges as needed but don't use entire columns for perfomance reasons.