Simple Spreadsheet for golf scores

Griffiths · Newbie Joined: 25 Apr 2012 Posts: 1

Hello, I'm trying to create a simple spreadsheet application to keep track of golf scores for some friends and I. I would like for it to keep our average score for each hole, as well as our average score for each round.
I've had a lot of success so far, but I'm now running into a problem. I need the spreadsheet to not take into account zeros (or blank cells as zero).

I've set it up so that we can just plug in our scores for the first 25 rounds, but having played only 12 thus far in the season I've got it creating an overall average of the 12 rounds, plus the 13 rounds that have been left blank. Can anyone help me out with this? Is it a simple formula that I can use?

Corfy · Posted: Wed Apr 25, 2012 11:57 am Post subject:

How about something like this (adjust the ranges to fit your specific sheet):

=(SUM(B2:Z2))/(COUNT(B2:Z2))

This should give you a sum of every number that is in row 2 (from column B through Z) and then divide it by the number of cells that you have populated in that range (that is what the "count" is for.. it counts the cells that have been filled). In this example, the formula would go in AA2, but as I said, feel free to adjust as you see fit.

However, any cell that actually has a "0" in it would be counted. Just wanted to warn you.
_________________
Laugh at life or life will laugh at you.

karolus · OOo Advocate Joined: 22 Jun 2011 Posts: 208

Corfy · Posted: Wed Apr 25, 2012 12:53 pm Post subject:

jrkrideau · Posted: Thu Apr 26, 2012 3:53 am Post subject: