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

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.