Double Drop Down Add Up

[dejaagermeister]

Hello, I was wondering if its possible to have two drop down selections auto fill in another tab? 

Example: One drop down would have a Set Number (101,102,103 etc), the other would have a dollar amount ($100, $200, etc). I'd like to know if I selected 103 & $200 if it would take that info and add it to a total on another tab? 

Another example: Name 1 - 103 - $200, Name 2 - 103 - $500, and Name 3 - 103 - $100 = 103 - $800

[#2]

@dejaagermeister 

Let's say the numbers 101, 102 etc. can be selected in B2:B100 on Sheet1, and the amounts in C2:C100. on the same sheet.

On another sheet, you could create a pivot table based on the data, with the number field in the Rows area and the amount field in the Values area.

Alternatively, enter the numbers 101, 102 etc. in - for example - A2, A3, ...

Enter the following formula in B2, then fill down:

=SUMIF('Sheet1!$B$2:$B$100,A2,$C$2:$C$100)