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
Our community of experts have been thoroughly vetted for their expertise and industry experience.