Counting the number of Checked Boxes

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?


Best Answer

  • 1996mustang
    Answer ✓

    I figured it out...

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