Countifs no longer working

Nwest

Hello,

I have a countifs formula that was working and is no longer...

This is for my "metrics" sheet so the information is being pulled from the Garage Access Issues Log onto another sheet so I can use it in a Dashboard.

I'm trying to count how many issues are showing as unresolved and not archived. Both the 'Resolved' and 'Archived' 'columns are checkboxes. Below is the formula I have.

=COUNTIFS({Garage Access Issues Log Resolve}, =0, {Garage Access Issues Log Archive}, 0)

Below are all the columns of the source sheet if that helps

Thank you in advance!!

Paul Newcome

Are you getting an error message?

Nwest

There's no error message. It's just returning a value of 0 when there are 2 open issues

Paul Newcome

Ok. Let's try indicating "not equal to checked" instead of "equal to unchecked". It shouldn't make a difference, but I have seen that work sometimes.

=COUNTIFS({Garage Access Issues Log Resolve}, @cell <> 1, {Garage Access Issues Log Archive}, @cell <> 1)