add a number if a cell = 0

[carcharoth]

Hi all this is my first post.The problem I am having is I am running a small office pool for Nascar.We use 8 starting drivers and a spare.You only get to use your spare if one of your starters doesn't start for some reason or other.My question is what formula would I use to to give 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 m2 to m9 and the numbers come from the b column: ex in m2 I typed =b7 how do I add mark martins score in if a stater score is 0 and dont add it if all my starters do score a point any help would be appreciated.

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

[oldchippy]

Hi carcharoth,

Welcome to the forum, I'm not quite sure whether I've got your requiements correct, but here's my first attempt.

[carcharoth]

Thank you for the formula it works great.I appreciate the help

[oldchippy]

Glad to hear it worked for you - thanks for the feedback