Hello there,
I'm using the following =COUNTIF(A6:G6,"*Failed*") in the attached workbook, but I'm trying to figure out how to return a BLANK instead of 0 when value is not met.
Any idea please?
Another formula to use maybe?
Thanks
Hello there,
I'm using the following =COUNTIF(A6:G6,"*Failed*") in the attached workbook, but I'm trying to figure out how to return a BLANK instead of 0 when value is not met.
Any idea please?
Another formula to use maybe?
Thanks
H5=IF(COUNTIF(A5:G5,"*Failed*")=0,"",COUNTIF(A5:G5,"*Failed*"))
Awesome! Thanks a lot
Another option, if your interested.
=IFERROR(1/(1/COUNTIF(A5:G5,"*Failed*")),"")
So cool, thanks a lot, this is more simplified but both works amazingly
Glad to help & thanks for the feedback.
Another option I use is that I use conditional formatting >> cells that contain >> equal to >> 0 then format the font the same as the cell fill color and they disappear, FWIW.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
File/Option/Advance/ Show a zero in cells...
release stick
Quang PT
Conditional formatting could be used in custom format [=0]"";General
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks