Forum Discussion
Double Drop Down Add Up
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
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)
