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.
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
All_phone_types.csv
Asked:
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get this solution by purchasing an Individual license!
Start your 7-day free trial.
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.
You're right... sorry about that.
All_phone_types.csv
All_phone_types.csv
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
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
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?
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.
-
Microsoft ApplicationsCertification: IC3 GS4 Internet Core Competency Global Standard 4… 135 lessons
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get this solution by purchasing an Individual license!
Start your 7-day free trial.
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.