Total vendor costs using two named ranges together
Real problems with no formula named for you. You decide what to use.
This vendor cost sheet also tracks each contract's status, which isn't needed for this total. All four costs have been named "Expenses" in Name Manager, and the markup rate has been named "Markup". Compute the total cost including markup, using both names, not a raw cell or range reference for either.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Vendor | Cost | Status | Markup |
| 2 | Vendor A | 400 | Active | 0.15 |
| 3 | Vendor B | 250 | Active | |
| 4 | Vendor C | 600 | Expired | |
| 5 | Vendor D | 150 | Active | |
| 6 | Total incl. markup |
This is the actual sheet the case study hands you, including whatever column turns out not to matter. Figuring out what to ignore is part of the exercise.
Why this one matters
Combining two named ranges in one formula, a total plus a rate, is what Name Manager is really for once a workbook has more than one thing worth naming.
More case studies
- What would the payment be on this financing deal?
- When does this project actually finish?
- Which region needs attention?
Case Studies are part of the full unlock
Case Studies are locked until you unlock the full site: real, messier problems with no function named for you, graded the same way every Practice exercise is. Open this one to see how to unlock the rest.
Open this case study →