Need EXCEL help with a SUM function

I have the attached spreadsheet in csv format to work with. Basically it's a list of locations  by Airport code (APK, DFW, UKR, etc) and the different model phones at those locations.   What I would like to do (not sure if it's possible) is take this list and get a count of each phone type (7940, 7941, 7962, etc) by location.  So, I would need it to somehow get a SUM based on location and model of phone.... I'm guessing I would need to insert or create a different function for each location?  I'm really a novice at EXCEL so I would greatly appreciate any help.
All_phone_types.csv
LVL 1
Vontech615Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Katherine HainesSenior Software Development EngineerCommented:
Hopefully I'm following correctly, since your data isn't labeled. Is one column the location, and another the phone type?

If so, I would try doing it in two steps:

=CONCATENATE(text1, [text2], ...)
=COUNTIF (range, criteria)

Make a new column that is concatenating the two columns that are your location and type. For example it could look like this =CONCATENATE(A1, C1) and then you'd "fill down" for the rest of the column.

Now make another new column for occurrences. =COUNTIF($D$1:$D$5933, D1) and also "fill down" for the rest of the column.

For a lot more detail about countif, check this out.
Vontech615Author Commented:
Sorry, please see new file.... I've cleaned it up and added location and phone type.
Katherine HainesSenior Software Development EngineerCommented:
I think perhaps you forgot to attach the file?
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Vontech615Author Commented:
You're right... sorry about that.
All_phone_types.csv
Katherine HainesSenior Software Development EngineerCommented:
I'd still use the same technique I recommended. Do you have anymore questions?
Lopo PegadoProject ManagerCommented:
You can convert to excel and use pivot table.

Here as an example (added one collumn filled with "1" to count the phones you can use any other column you have like phone number or serial number  on the values of the pivot table
All_phone_types.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vontech615Author Commented:
Wow, Lopo, that is exactly what I was looking to do and it looks like you've already included all the phones per location. That was quick. Can you point me to some good reading on how to work with Pivot tables?
Katherine HainesSenior Software Development EngineerCommented:
I never think of pivot tables, I guess because they frustrate me.

But I would start here if I wanted to read more about them.
Vontech615Author Commented:
Thank you both for your help!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.