Ignore blanks when using COUNTIF

**mattmac** · 05-27-2011, 04:41 AM

Hi guys,
Need a little bit of help - i need to use this:

=IF(OR(C4="",COUNTIF('CMDB'!R:R,C4)>0),"In CMDB", C4&" missing from CMDB.")

but i want to ignore blanks ... any ideas?

Thanks in advance for your help

**zbor** · 05-27-2011, 04:45 AM

You mean:

=IF(A4="", "", IF(OR(C4="",COUNTIF('CMDB'!R:R,C4)>0),"In CMDB", C4&" missing from CMDB."))

**mattmac** · 05-27-2011, 04:54 AM

I dont want blanks to be either of these: "in CMDB" or "Not in CMDB"

basically im comparing a two lists of IPs

**zbor** · 05-27-2011, 04:56 AM

This? =IF(OR(C4<>"",COUNTIF('CMDB'!R:R,C4)>0),"In CMDB", C4&" missing from CMDB.")

Re: Ignore blanks when using COUNTIF