In the below image, is there a feature in excel that would enable me to quickly count out the total number of entries contained within a the zipcode? I could manually do this easily in this example, but the database I have is very large.
count.jpg
In the below image, is there a feature in excel that would enable me to quickly count out the total number of entries contained within a the zipcode? I could manually do this easily in this example, but the database I have is very large.
count.jpg
Change the range reference B2:B6 to your range, if required.PHP Code:
=COUNT(B2:B6)
Hope that helps!
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
You can use a pivot table for that.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi
If the zip codes in output list are already written then can use countif function
RegardsPlease Login or Register to view this content.
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks