One way:

=IF(SUM(COUNTIF(A1:E1,{"SS","LS"})) 0, 1, 0)

or more compactly:

=--(SUM(COUNTIF(A1:E1,{"SS","LS"})) 0)


In article ,
"Natalie" wrote:

Sorry, I still can't make it work -

I want to add all the SS and LS together, and if they are more than one,
have a 1 appear, and if the answer is 0 then a 0 appear?

Thanks for all your help

"JE McGimpsey" wrote:

One way:

=COUNTIF(A1:E1,"SS")

In article ,
"Natalie" wrote:

What if I wanted to count the number of SS or LS in these cells?