add a number if a cell = 0

[carcharoth]

Hi all this is my first post.The problem I am having is I am running
small office pool for Nascar.We use 8 starting drivers and a spare.Yo
only get to use your spare if one of your starters doesn't start fo
some reason or other.My question is what formula would I use to to giv
the spare points only if one of the starters don't score. Ex:

Jeff Gordon 51
Carl Edwards 106
Denny Hamlin 117
Dale Earnhardt 143
Kasey Kahne 151
Regan Smith 55
Aric Amirola 0
David Reutimann 109
Total 732
Mark Martin 0
Grand Total 732

The number column beside each driver is my M column m2 to m9 and th
numbers come from the b column: ex in m2 I typed =b7 which was 51 ho
do I add mark martins (he would be m11 and his score would be i
b16)score in if a stater score is 0 and dont add it if all my starter
do score a point any help would be appreciated.

P.S if this is the wrong forum for this question please don't get ma
just send me to the correct forum.Thanks for any hel

 

[T. Valko]

Try something like this:

=IF(COUNTIF(M2:M9,0),B16,0)

 

[carcharoth]

Thank You.That formula worked I appreciate all your help

 

[T. Valko]

You're welcome. Thanks for the feedback!