troubleshooting Question
Need EXCEL help with a SUM function
asked on
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
All_phone_types.csv
The Value of Experts Exchange in My Daily IT Life
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>
Mike
Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 2 Answers and 9 Comments.
View membership options“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck
Member since 2004
Our community of experts have been thoroughly vetted for their expertise and industry experience.