Count cells from another sheet <> to a value or is blank

Geoff Hill

I am trying to count cells from another sheet that do not equal certain values OR are blank. When I create a filter on that sheet, I find 40 cells that fit the criteria.

However, my formula from my Metrics sheet counts 0 cells.

COUNTIFS({Subtype}, <>"Electronic Messaging", {Subtype}, <>"Core Sales Aid / Visual Aid", {Subtype}, <>"AUTOMATIC", {Subtype}, OR(ISBLANK(@cell)))

Any ideas what I'm doing wrong?

Kelly Moore

Hi @Geoff Hill

Try this

=COUNTIFS({Subtype}, OR(ISBLANK(@cell), @cell <>"Electronic Messaging", @cell<>"Core Sales Aid / Visual Aid", {Subtype}, @cell<>"AUTOMATIC"))

cheers