Tally up years in a column

Hi, I'm sure this must be straight forward but I can't work it out.

I have a list of jobs which have years allocated. I want to see in total how many jobs I have booked in 2026/27/28 and for the tally to show to the right of this in column G. How can I achieve this? Many thanks!

MacBook Pro 14″, macOS 26.1

Posted on Nov 6, 2025 4:07 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 6, 2025 6:05 AM

It looks as if you have added a Category to your table.


To get the counts, you can do this:


Click the gear icon:


Choose Count from the dropdown:





Result:



Intro to categories in Numbers on Mac - Apple Support



You can also get counts in a few seconds with a Pivot Table:


Intro to pivot tables in Numbers on Mac - Apple Support




SG



2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Tally up years in a column

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.