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(Click on the pics for a better view):
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:
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!
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:
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!
