
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 07:36 AM
Hi!
I am trying to build a formula but I haven’t quite found the solution in the community.
I have a table with different customers information, with fields such as “name”, “surname”, “email”, “phone”, “company”…
I would like to create a separate table in which I can count how many customers I have from the same company.
So let’s say I have:
Table 1:
customer 1 — Company A
customer 2 — Company A
customer 3 — Company B
customer 4 — Company C
customer 5 — Company C
customer 6 — Company C
In table 2, I would need to show:
Company A — 2
Company B — 1
Company C — 3
I have the company field built as “single select”, since I work with a limited and specific list of companies. Not sure this makes any difference in terms of formulas.
Thanks a lot in advance!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 07:45 AM
You would need to change your single select field to a linked record field, so you end up with a table of companies. Then, in your table of companies, you can create a field of type “Count” to count how many people are linked to each company.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 07:45 AM
You would need to change your single select field to a linked record field, so you end up with a table of companies. Then, in your table of companies, you can create a field of type “Count” to count how many people are linked to each company.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 08:20 AM
Works like marvels, thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 29, 2022 08:41 AM
You’re welcome! :slightly_smiling_face:
Also, since you’re new to Airtable, I’ve got lots more tips & tricks like this in my free Airtable training course:
