Count of different fields having a value of 5

This discussion was created from comments split from: COUNTIFS with OR.

Answers

  • Caravan
    Caravan ✭✭✭✭

    Hi Community,

    I have a different use case of COUNTIFS and OR and hoping some smart SS guru can help.

    I life to get a count of different fields having a value of 5. COUNTIFs automatically assumes "AND" so I like to use "OR". I've searched the community articles but with no avail.

    =COUNTIFS([PM/PM]@row, 5, [PM/SSB8]@row, 5, [PM SSB9]@row, 5, [PM - Change Mgmt]@row, 5, [PM - Agile]@row, 5)

    Answer s/b 1

    Thank you in advance.

  • Leibel S
    Leibel S ✭✭✭✭✭✭

    @Caravan

    Are you trying to get a count of how many each of those cells have 5?

    If yes then:

    =COUNTIFS([PM/PM]@row:[PM- Agile]@row, @cell=5)

    If you wanted to return a check box (saying that at least 1 of those have 5), then:

    =IF(COUNTIFS([PM/PM]@row:[PM- Agile]@row, @cell=5)>0,1,0)

  • Caravan
    Caravan ✭✭✭✭

    Thank you Liebel

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!