here is my formula
=sum(b4:b8)-max(b4:b8)

again it will give me only the total of 3 golfers if only 4 play, sometimes
the fifth doesn't show up and a zero is entered. So I do I 4 scores but
again only 3 are added. I have to throw out the highest if all 5 players
show up.


"Bryan Hessey" wrote:


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