Simple formula to Count the entries in Column G and provide me with a total

Question

Level 1

6 points

Simple formula to Count the entries in Column G and provide me with a total

I need a simple formula to Count the entries in Column G and provide me with a total. For example, there are 40 total entries in column G, and I need the footer row to calculate 40 without counting count 0s (zeros) or changing the range every week, which can vary.

See Attached screenshot

** Please note that Column G's data formatting is set up as Number and not automatic or text.

Numbers version version 13.2 (7038.0.87)

macOS 13.6.1 (22G313)

Thank you,

MacBook Pro 16″, macOS 14.1

Posted on Oct 30, 2023 2:16 PM

Reply

Answer 1

Recycleur

Level 4

1,633 points

Oct 30, 2023 2:40 PM in response to chadb427

Without including the zeroes

When you're entering the formula, click on the G at the top of the column instead of selecting a range of cells.

Note that if you don't want to include the title row in the count you have to set it as a header row in Table Format.

Reply

Simple formula to Count the entries in Column G and provide me with a total

Similar questions