Counting the number of Checked Boxes

1996mustang · 05/20/22

I have a column name Phase I and I want to count all the checked boxes from row 1 through row 20. I am using the following formula:

=COUNTIFS([Phase I]1:[Phase I]20, =1) What I get is #Boolean Expected?

Any Suggestions?

Regards

1996mustang · 05/20/22

I figured it out...

=COUNTIFS([Phase I]1:[Phase I]20, =1) + ""

1996mustang · 05/20/22

I figured it out...

=COUNTIFS([Phase I]1:[Phase I]20, =1) + ""

Dan W · 05/20/22

This Thread has a great explanation

Best Answer