Gavin,

Try something like this.

=IF(SUM(F6:I6)0,SUM(F6:I6),IF(AND(COUNTIF(F6:I6," TR")0,COUNTIF(F6:I6,"ND")0),"TR",IF(AND(COUNTIF( F6:I6,"TR")0,COUNTIF(F6:I6,"ND")=0),"TR","ND")))

I used F6:I6 for my range to evaluate, change those as needed. In your
sample data this returned 2,1,TR,TR and ND respectively. This assumes
that if there are no numbers, there will always be "TR"'s and/or "ND"'s
in the cells.

Does that help?

Steve


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