Countif equivalent (count matching text in a particular field)
I have been looking on this forum and others and I have yet to find a solution that addresses my problem. I want to be able to count the number of records that have a particular text value in a particular field. Here's the situation:
One of my layouts is a map, and it's based on my "Company Data" table. Clicking on a city will (or will eventually) show a summary of the companies in that area. So far, I have a very basic splash page that shows the total count of companies, as well as the top 5 companies as ranked by size. However, I would like to add the count of companies by "style" (a field within the Company Data table). Each company is assigned one of 10 or so styles. I have tried various combinations of valuecount formulas and global calculations, but I can't seem to find anything that works. This would be an exact replication of the =COUNTIF formula in Excel, if that helps.