Thanks
What if I wanted to count the number of SS or LS in these cells?
"JE McGimpsey" wrote:
One way:
=IF(SUM(A1:E1)1,1,0)
or, more compactly (using the fact that XL coerces TRUE/FALSE to 1/0 in
math operations):
=--(SUM(A1:E1)1)
where the first - coerces TRUE/FALSE to -1/0, and the second back to 1/0.
In article ,
"Natalie" wrote:
How do I say
If the sum of A1:E1 is greater than 1, enter a 1 in the column, but if not
then enter a 0?
|