Numbers Formula on my MAC Pro

Hi Smokey,

I'd start by making some changes in the table to avoid columns where the data switches format between numbers and dates. This simplifies the formulas used.

List the dates in column A, and the number of strokes on each hole in a separate column, as shown below.

Rows 1 and 2 are defined as Header rows.

Rows 16 and 17 are defined as Footer rows.

This allows a 'full column reference, as seen in the SUM formula, that actually includes only the body rows (3 to 15 in the example) omitting the Header rows and Footer rows in the SUM formula shown above, and in the Count formula shown below.

SUM above sums the values in all body cell of column A. Blank cells are treated as zeros.

This formula, in B17, multiplies the par value in row 2 of its column by the COUNT of scores entered in that column.

COUNT counts only the cells that contain numbers or quasi-numeric values (such as Date and Time values). The result is 'Par' for the number of scores recorded for each hole.

Enter the formulas a shown in the footer rows of column B, then fill then right to the column for the last hole.

Regards,

Barry

Hi niloherrera,

Did you mean…

If so, what does the image have to do with Smokey's question?

Regards,

Barry