Using a checkbox to countif

michael.vanhuss

I am trying to count based on 2 criteria if checkbox is checked. So far it only returns a zero value when the checkbox is checked. Here is what I have...

=COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, "true", {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5, {Real-Steel Estimator Review Total Loss Tes Range 3}, Client3)

Where tes range 1 is the checkbox and range 2 and 3 are the criteria. Any thoughts? What am I missing?

Brian W

Checkbox values are 1 and 0. Try this:

=COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, 1, {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5, {Real-Steel Estimator Review Total Loss Tes Range 3}, Client3)