SUMIF's ???

[madman1734]

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

[DavidJAllen]

madman1734,

If I understand you correctly the following formula should help

=(D3+C3*NOT(ISBLANK(D3)))+(E3+C3*NOT(ISBLANK(E3)))+(F3+C3*NOT(ISBLANK(F3)))

In each case if a score is not present then the handicap gets multiplied by 0 and hence the handicap has no effect. If a score is present then the handicap gets multiplied by 1 and is therefore added to the score.

Hope that helps.


Regards

David

[madman1734]

David,

That works great. This will definitely make the tournament a lot easier.

I appreciate the help.

mm