AnsweredAssumed Answered

Countif equivalent (count matching text in a particular field)

Question asked by trialuser1111 on May 11, 2009
Latest reply on May 21, 2010 by DRJAustin


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.