Thanks Williams, I am almost there. I need to have it count the cells that
have
a number greater than 0 and then count each cell as 1 and then assign the
following. If the cells have all 0 I need it to = N
1-3 cells with a number greater than 0 = I
3-4 cells with a number greater than 0 = S
all 0 in each cell = N


"William Horton" wrote:

If you keep getting OTHER it means that the count must be greater than 4. If
you want it to be S if it is 4 or greater change the formula to:

=IF(COUNT(A6:A13)=0,"N",IF(AND(COUNT(A6:A13)=1,CO UNT(A6:A13)<=3),"I",IF(COUNT(A6:A13)=4,"S","Other ")))

Hope this helps.

Bill Horton

"Vick" wrote:

Thanks William, but the answers keep saying "other"

"William Horton" wrote:

Try the following formula (which assumes your range of cells you want checked
is A6:A13.

=IF(COUNT(A6:A13)=0,"N",IF(AND(COUNT(A6:A13)=1,CO UNT(A6:A13)<=3),"I",IF(COUNT(A6:A13)=4,"S","Other" )))

Hope this helps.

Bill Horton

"Vick" wrote:

Excel 2003 I need to create a formula that would count each cell with a
number in it as 1 and assign a letter
if cells adds up to 0 = N
if cells adds up 1-3 = I
if cells adds up to 4 = S