Without seeing your formula it would be hard to say, however, if you set
the 'score cell' to a format of ##0 you can then use something like
=COUNTIF(A:A,"<")
to count the zero values too.

You will need to adjust the A:A reference to suit your needs.

--

Tommy Wrote:
I have 5 players on your team and I must throw out the highest score, i
know
how to do that, but if only 4 players show up it only give me a total
for 3
players and all 4, how do i get it to see the 0 score entered and not
messup
my formula.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=530224