countifs formula

Terri S

I am trying to find the formula to count if something is found in one column and somethings else is NOT found in another column

kowal

hi Terri,

would this help?

=COUNTIFS(ColumnA:ColumnA, "Test", ColumnB:ColumnB, NOT("Test"))

Terri S

Says invalid operation. Here is my formula

=COUNTIFS({SJMC Oracle Health Issue Form Range 1}, "1-Critical", {SJMC Oracle Health Issue Form Range 4}, NOT("Closed"))

AravindGP

Hi @Terri S

You can try this.

=COUNTIFS({SJMC Oracle Health Issue Form Range 1}, "1-Critical", {SJMC Oracle Health Issue Form Range 4}, <>"Closed")