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!

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!