Calculation Based On Dropdown list Selection Excel

**rnohoy** · 04-26-2013, 05:37 AM

I need your help!

I've been visualizing this but I don't know what to do.

I have a Sales Monitoring excel sheet for manual inputs. I have also a Summary sheet to show the total Revenue and Cost based on the dropdown selection.

The Sales Monitoring Sheet has four categories namely facebook likes, twitter followers, youtube views, website traffic. Each has specific amount in of Revenue, cost and profit to be entered manually in Sales monitoring sheet.

Now, what I want to do is the Sales Summary sheet - should calculate the total Revenue, Paypal fee, cost and profit for each category. There should be a dropdown list of the category (facebook likes, twitter followers, youtube views, website traffic) and in the other columns should have the total cost/profit for all of the sales in that category.

So, when I select "Facebook likes" category (dropdown lists) in the Sales Summary, it will classify all the entries from the Sales Monitoring sheets, sum it up and display automatically to the total Revenue, Paypal fee, cost and profit columns of the Sales Summary sheet.

I have attached the sample worksheet.

Thank you so much for your help.

**Lemice** · 04-26-2013, 05:49 AM

Hello,

Please check if the attached file is what you are looking for.

**rnohoy** · 04-26-2013, 06:02 AM

Hello Lem,

Very excellent! How did you do that?

. Impressive!

Thank you so much!

**Lemice** · 04-26-2013, 06:09 AM

I used the following formula on Cell C3

Please Login or Register  to view this content.

Basically the first part is the "Look for" - if the Cell on the left of the formula ("Facebook Likes" on this example) is found on the Services Category column on Table1 worksheet, then take the value on worksheet Table1 column Revenue on the same row in which it's found, then add them together.

Anyway, glad that I could help. If this is the solution you are looking for, please mark the thread as [SOLVE] using the Thread tools right above the #1 post.

Have a great day.