CountIF cell does not contain TEXT or is BLANK

[nparsons75]

Hi,

I need to count a range of cells that are non blank and does not contain the text "COMPUTER".

I can get it to do one thing but not both using

=COUNTIF(D11:D43,"<>*COMPUTER*")

Thanks,

 

[Joe4]

Try this:

=COUNTIFS(D11:D43,"<>*COMPUTER*",D11:D43,"<>" & "")

 

[barry houdini]

Try using COUNTIFS with an extra condition, i.e.

=COUNTIFS(D11:D43,"<>*COMPUTER*",D11:D43,"<>")

 

[nparsons75]

Brilliant, thank you very ,much....great help.