I am new to Airtable and still learning the basics. In Airtable I have a list of websites I manage, including a column for the webhost. My goal is to make a way to quickly see how many sites are on each host. When the list was in Excel, I used the COUNTIF:
A B C Domain Host Host Count site1.com hostA 2 site2.com hostA 2 site3.com hostB 1
I also made a pivot table that had in the first column a list of the unique entries in the host column in the main sheet, and in the second column the count
Host Total hostA 2 hostB 1
Is this possible in Airtable? Could someone point me in the right direction as to which features to use?