Forum Discussion
Solved
How to ignore formulas that return blank cells in COUNTIF
I have a worksheet (worksheet "A") where one column is pulling dates using a VLOOKUP formula from another worksheet (worksheet "B"). On another worksheet (worksheet "C"), I am trying to count the cel...
Try
=COUNTIFS(Table2[Spec/ Build],"*spec*",Table2[Permit Rcvd],">0",Table2[P.O. Release],">0",Table2[GL],"0")
or
=SUMPRODUCT(ISNUMBER(SEARCH("spec",Table2[Spec/ Build]))*(Table2[Permit Rcvd]<>"")*(Table2[P.O. Release]<>"")*(Table2[GL]=0))
Try
=COUNTIFS(Table2[Spec/ Build],"*spec*",Table2[Permit Rcvd],">0",Table2[P.O. Release],">0",Table2[GL],"0")
or
=SUMPRODUCT(ISNUMBER(SEARCH("spec",Table2[Spec/ Build]))*(Table2[Permit Rcvd]<>"")*(Table2[P.O. Release]<>"")*(Table2[GL]=0))
- That first solution is perfect, since the value being returned is "0" anyways. Thanks for the help! I'm a little sad that I didn't realize that myself! This forum has been very helpful for me!
