Count of different fields having a value of 5

System

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

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

@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

Thank you Liebel