Count Values

Zenaida · #1 (**permalink**) 06-09-07, 15:54

I run a report from a Customer Relation Management Tool. I'm able to export the information into Excel. The report shows the cities and states that customers live in.

The only fields I export are the city and state. So if I have 50 customers that live in Las Vegas Nevada, Las Vegas Nevada would be listed 50 times.

I need to get a count of the number of times each city is listed. Because the same cities don't always show up on the report when I run it, I'm not sure how to automate it.

Is there a way to do this with a function?

Thanks.

gvee · #2 (**permalink**) 06-10-07, 09:02

The following is an SQL query that would give you the answer you wanted.

Code:

SELECT City, State, Count(*)
FROM MyTable
GROUP BY City, State

Start to think of your columns as columns in a table.
HTH

Zenaida · #3 (**permalink**) 06-10-07, 21:23

Thanks for your reply. In Excel, where would I enter the code? Would the syntax you wrote work in Excel? Thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech