Hello! So now I will explain myself better. I'm doing this for a school project but I am not sure about the formula. I am doing reference about sold mobile phones in a techno shop. But I have made a drop-down list for the models of the mobile phones because, you know, there are a lot of different kinds. I have made a column about the number of the phones at the beggining of the month. Here's a picture to understand me better:
Untitled11.png
So what I want to do is to sum all of the phones at the beggining of the month. I'll give an example. Here is the formula I have used for cell E4:
Untitled2.png
What I want to do is to basically sum these values so 40+50+30+40=160. So we have 160 mobile phones brand Huawei. I want to sum the numbers of iPhone,Samsung,LG,Nokia the same way. Let's say that they are 300,200,450,150. So the result i want to get at cell C11 is the total number of the mobile phones at the beginning. Basically 160+300+200+450+150=1260. This was just an example. I really hope you understood me. It's really important. Is there a formula for this? Thank you in advance!
P.S. I have posted this thread on other forums as well. Here are the links:
https://www.mrexcel.com/forum/excel-questions/1005216-how-sum-values-based-drop-down-list.html
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_windows8/how-to-sum-values-based-on-drop-down-list/eb382430-4126-4e93-aca8-fb3f19a77ac0?tm=1494766849944
Bookmarks