In excel, How can I total a column linked to a drop down

June 12, 2018 at 11:48:49
Specs: Windows 10
I am creating a worksheet which has a drop down list, set up to auto-populate the $ value of the item selected in the second column of the table. In the second column, I used an index/match formula to get it to auto-populate the value. Which is perfect, but the problem I have now run into, that I cannot get figured out, is I need to get a column total for that column with those values, and cannot for anything find out how to get it to work. I have tried many other formulas, but I can not get the column to total.
Does anybody know how to sum up this column?

See More: In excel, How can I total a column linked to a drop down

Reply ↓  Report •

#1
June 12, 2018 at 13:19:11
I'm confused.

Let me see if I have the concept right, using actual column letters as examples. If I don't have the concept right, please post some type of similar example so that we can understand the layout of your sheet.

In the following example, the Column A Drop Downs would be populated with the list of Items in Column D.

The Index/Match formula in Column B would pull the value from Column C, based on the Drop Down choice.

       A                 B                  C         D      
1  Drop Down     Index/Match Formula      Value      Item 
2  Drop Down     Index/Match Formula      Value      Item 
3  Drop Down     Index/Match Formula      Value      Item 
4  Drop Down     Index/Match Formula      Value      Item 

If that is correct, a SUM function in B5 would SUM the values returned by the Index/Match formulas in B1:B4.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question