Excel: Sum values from range based on cell - TechRepublic
Question
April 3, 2013 at 06:38 AM
stephenconnolly

Excel: Sum values from range based on cell

by stephenconnolly . Updated 13 years, 2 months ago

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

This discussion is locked

All Comments