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

"SteveG" wrote:


Vick,

Try,

=IF(COUNT(A1:A5)=0,"N",IF(COUNT(A1:A5)<=3,"I","S") )

A1:A5 is your range to count.

COUNT will also count dates if they appear in your range.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570030