Question Locked
Excel: Sum values from range based on cell
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Using a drop down list to select multiple values is it possible to sum based on the different values?
Range
Item Value
Item 1 10
Item 2 20
Item 3 50
Item 4 40
Item 5 30
Selected SumTotal
Item 1 10
Item 2 20
Item 1, Item 2 30