Count Multiple Data in a column

[Guest]

Have a spreadsheet that lists all of our company vehicles as follows.
A B C D E
1 UNIT# Make Model Desc. Location
2 101 GMC Van 1/2 T BT
3 119 Chevy Van 1/2 T BT
4 81 Ford Van 3/4 T GR
5 32 Chevy Van 1/2 T GV
6 101 GMC Van 1/2 T SB
What I am looking to do seems like it should be simple....But I can't come up with an answer. I want a count of the number of vans that I have in each different location. Any ideas?

 

[Andy B]

Well, if you don't like our pivot table suggestions from earlier, how about
sorting the sheet on Location and using subtotals to count the number?

--
Andy.

Have a spreadsheet that lists all of our company vehicles as follows.
A B C D E
1 UNIT# Make Model Desc. Location
2 101 GMC Van 1/2 T BT
3 119 Chevy Van 1/2 T BT
4 81 Ford Van 3/4 T GR
5 32 Chevy Van 1/2 T GV
6 101 GMC Van 1/2 T SB
What I am looking to do seems like it should be simple....But I can't come

up with an answer. I want a count of the number of vans that I have in each
different location. Any ideas?

 

[Guest]

Could you use a Countif function? =countif(E2:E6,"=BT") will give you 2. You could have one for each location. You might also want to look at the database function DCOUNT if your data is more complex or you need more criteria than just location.