Hello,
I have created a Database of Buildings, I now won't to count the number of different Locations that are listet in the database, with wich function can i do that? I have only found functions to count numbers.
Hello,
I have created a Database of Buildings, I now won't to count the number of different Locations that are listet in the database, with wich function can i do that? I have only found functions to count numbers.
u can use countif/countifs(for more criteria)
or share a sample file...
Maybe something like this...
=COUNTA(A2:A100)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Look at the Countif function.
Formula:Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks it worked out just fine.
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks