This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If you're looking for just one location, you can Filter for that location, and then use a summarize tool to count the records. The Filter effectively sets up the IF part of the CountIf, by specifying the criteria.
If you would want all records per location, then add a Summarize tool, use location as the Group By field, and another field with a Count.
Thanks for your response. I tried that and appended it with original data so as to add a new column but the number of rows multiplied. So, wasn't sure if that would work. But, I'll think over it again now.