Counting the number of Checked Boxes

1996mustang
1996mustang ✭
in Formulas and Functions

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?

image.png

Any Suggestions?

Regards

Best Answer

  • 1996mustang
    1996mustang ✭
    Answer ✓

    I figured it out...


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

Answers

Categories