Not sure if this has been posted before or not. Not sure if it is even possible.
I am creating a golf Scorecard. The points column has the IF function to work out the points depending on the score. This has worked fine. The problem is trying to total up the points column. I am using the SUM function and it keeps totalling 0 even though there are points in the cells.
Can anyone help? What to i need to do to get the points column to total.
I am creating a golf Scorecard. The points column has the IF function to work out the points depending on the score. This has worked fine. The problem is trying to total up the points column. I am using the SUM function and it keeps totalling 0 even though there are points in the cells.
Can anyone help? What to i need to do to get the points column to total.