Question

Locked

Excel: Sum values from range based on cell

By Stephenconnolly ·
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 conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums