Hey all,

I am a bit new to formulas and need a little help.

I am creating a spread sheet for a bowling tournament that about 80 - 100 of us form every year. Prizes are handed out for good performance.

What I need help with is the following:
Current formula for G3 is =IF(D3>0,SUM(D3:F3,C3,C3,C3),"0")
G3 needs to be the sum of D3+C3(handicap),E3+C3,F3+C3. The problem is that if there is no score to input for D3, E3 or F3 then C3 gets added all 3 times when it needs to add only if there is an input for each.

Hope that is understandable.

Any help would be appreciated.

mmSpreadsheet.xlsx