COUNTIFS on checkbox columns with multiple criteria


Is there a way to have a countifs formula on multiple columns? I want to count the cells where PM=Alex and there's a checkbox in the last 4 columns.

=COUNTIFS(PM:PM, "Alex", [Agenda 6/7/21]:[Agenda 6/7/21], 1, [Min 6/7/21]:[Min 6/7/21], 1, [Scorecard 6/7/21]:[Scorecard 6/7/21], 1, [Updates 6/7/21]:[Updates 6/7/21], 1)

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Christy Kooiman

    The current formula will only count the rows where all of your criteria are met, so where all 4 of those columns have a checkbox. This means if only 3 of the columns have a checkbox in a row, then this formula will skip that row.

    Are you instead looking to count each individual checkbox as a count of 1 (as long as it belongs to "Alex")? If so, you will want to add multiple COUNTIFS statements together, like so:

    =COUNTIFS(PM:PM, "Alex", [Agenda 6/7/21]:[Agenda 6/7/21], 1) + COUNTIFS(PM:PM, "Alex", [Min 6/7/21]:[Min 6/7/21], 1) + COUNTIFS(PM:PM, "Alex", [Scorecard 6/7/21]:[Scorecard 6/7/21], 1) + COUNTIFS(PM:PM, "Alex", [Updates 6/7/21]:[Updates 6/7/21], 1)

    Let me know if this makes sense and works for you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!