Help with a Drop Down List

New Contributor


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.



2 Replies
best response confirmed by Hans Vogelaar (MVP)



Maybe with SUMIF. Data validation is in cell B2 in this example.

data validation.JPG



@Quadruple_Pawn   YOU ARE THE BEST!!!! I just changed it according to my table and it worked!!! THANK YOU!!!