Formula to not Count Checkbox

Kris Guthier

I am working on building a SUMIFS formula to not count a certain row if a certain checkbox is checked in another sheet. I already have it counting everything if the criteria is correct, but having trouble adding the "NOT" if the checkbox is checked.

Thanks,

Kris

Amber Jackson

If a checkbox is checked, the program reads that value as "1". If it is unchecked, the value is "0".

In your SUMIFS, you can say if the box is checked perform action A, otherwise perform action B:

=SUMIFS([checkbox]@row=1, Action A, Action B)

Does that help @Kris Guthier ?

Kris Guthier

Thanks Amber, but I already have an @row for it to pull certain information as it's pulling specific type of projects.