# Dropdown Selection & Calculations

#### nymyth

##### Board Regular
Good morning/afternoon everyone,

I am in need of some assistance. Say I have a data tab where column A is a list of 100 stores, while column B is 'items sold'. In a second tab I have 5 cells in Column A that are dropdowns from the 100 stores, the 6th cell is "All Other". In column B is a vlookup to pull the 'items sold' amount depending on the selections in the 5 cells. What I am trying to do is pull the remaining 'items sold' in the 6th cell (All Other). This is a tricky as the selection of the 5 cells can vary and therefore the "All Other" cell will differ. Is there anyone that can help point me to a possible resolve?

Thank you.

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
To get the items sold for each store
=SUMIFS(Sheet4!\$B\$2:\$B\$11,Sheet4!\$A\$2:\$A\$11,Sheet5!A2)

To get the Other result:
=SUM(Sheet4!B2:B11)-SUM(Sheet5!B2:B6)

Sheet4 is where you have all your data
Sheet5 is the results

Jeff

Last edited:
Thanks Jeffery, this pointed me in the right direction. Had to make some tweaks to the SUMIFs, but it works like a charm.

Replies
4
Views
225
Replies
0
Views
91
Replies
0
Views
53
Replies
8
Views
185
Replies
4
Views
219

1,196,384
Messages
6,014,966
Members
441,860
Latest member
Store154

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back