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?
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 ItemIf 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