Link to home
Start Free TrialLog in
Avatar of Vontech615
Vontech615Flag for United States of America

asked on

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
SOLUTION
Avatar of Katherine Haines
Katherine Haines
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vontech615

ASKER

Sorry, please see new file.... I've cleaned it up and added location and phone type.
I think perhaps you forgot to attach the file?
You're right... sorry about that.
All_phone_types.csv
I'd still use the same technique I recommended. Do you have anymore questions?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
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.
Thank you both for your help!