Forum Discussion
dejaagermeister
Jun 07, 2022Copper Contributor
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 amo...
HansVogelaar
Jun 07, 2022MVP
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)