Only count items that aren't marked "complete" in the status column.

PKane

Hello All,

I am hoping someone might be able to help me w/ my formula? I'd like it to only count items that aren't marked "complete" in the status column. This is what I have so far:

=COUNTIFS({Remediations Category}, "NEC VIOLATION - ARC FLASH FAILURE", {Remediations Core OPCO}, "NSP", {Remediations Year}, "2022", {Remediation Status} I am not sure what to do here)

Any help or advice with this would be great - thanks in advance!

Purnima Gore

Hi

You can use the <> which means Not in the formula

=COUNTIF(Status:Status, <>"Complete")

Let me know if that helps :-)

Kind regards

Purnima

Project GPS

PKane

Thank you very much, Purnima for your reply! I am pretty new to formulas, and wanted to ask -

Should the formula look something like this?

=COUNTIFS({Remediations Category}, "NEC VIOLATION - ARC FLASH FAILURE", {Remediations Core OPCO}, "NSP", {Remediations Year}, "2022", {Remediation Status} Status:Status, <>"Complete")