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?
|