Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Counting values

Topic Labels: Formulas
Solved
Jump to Solution
1299 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Luxiel
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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.

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

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.

Works like marvels, thanks!

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: