Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Count number of rows with criteria

Topic Labels: Formulas
456 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello all,

I have one table with clients (1 row per client) and another table with Goals.

I would like to display the number of new clients (new rows) by month in the table Goals.

How should I do that ?

Thank you !
Jonathan

3 Replies 3

How is your [Goals] table set up? Do you have one goal record per month? One per year? I’ve got some ideas on how to do what you want, but knowing how goals and clients are linked (figuratively and literally) is important.

Hi Justin, thanks for the help.

I have one goal record per month.
In Goals, first column is month, second colum is the goal, and I would like the number of new clients in the third.
The other table is Contacts where I have dates, clients and non clients. I would like to count the number of new clients per month. Hope that helps !

It does. I’ll dive into this as soon as I can, but probably no sooner than Thursday morning my time (depending on my schedule).