Summing number of entries for many different entries

[lackofzack]

Hello,

I have a data set I am working with where I have a long list of zipcodes. I need to count for each individual zipcode, how many entries there are.

Here is a picture of my spreadsheet:

https://imgur.com/7mEewe5

I am having trouble attaching excel sheet to this post, so here is a dropbox download link: https://www.dropbox.com/s/cmgppdsmxa...zips.xlsx?dl=0

What I am looking for is a count for every individual zipcode of how many entries there are with that zipcode.

So it should looks something like:
For zipcode 90001: 251 entries
For zipcode 90002: 74
etc for all the zipcodes.


Thanks in advance!
Please let me know if you have any questions/need clarification

Zack

 

[lackofzack]

Solved the issue, need to use a pivot table and countif function!

Thanks!