i am making a golf spreadsheet for my upcomming outing, and i would like to have my excel spreadsheet auto-calc strokes per hole, so that i do not have to manually input the number of strokes per hole each player gets.

so if a person's handicap is 10, i would like for the sumif to see in the input box where i enter the "10", and have the range be <= to the person's handicap, make the value for the cell "strokes" to be "1".

if you are a golfer, as well as a good excel person, it would probably be helpful, since i'm sure i have confused some of you. sorry.