Forum Discussion
nyreddbone67
Jul 14, 2022Copper Contributor
Help with a Drop Down List
Hi,
I have a drop down list (Budget Category) and need a formula that when a category from this list is chosen it also pulls the dollar amount from the Amount Billed column to be placed in another cell. For example I have created another table with every category from the list and want the cumulative totals for each category. Hope I explained it correctly. Any help is appreciated.
Thanks!
=SUMIF($G$3:$G$22,B2,$H$3:$H$22)
Maybe with SUMIF. Data validation is in cell B2 in this example.
2 Replies
Sort By
- OliverScheurichGold Contributor
=SUMIF($G$3:$G$22,B2,$H$3:$H$22)
Maybe with SUMIF. Data validation is in cell B2 in this example.
- nyreddbone67Copper Contributor
OliverScheurich YOU ARE THE BEST!!!! I just changed it according to my table and it worked!!! THANK YOU!!!