Forum Discussion
Is it possible to select multiple options (which each have multiple associated values) and sum them.
OK. Here's a working example (but, again, the FILTER function will only work if your Excel is the most up-to-date version).
Here's an image of the final result I'm seeing. The cells with color in the background are the only cells with formulas in them, the green one being the only one with FILTER in it; its results "spill" into adjacent cells as needed.
I didn't make the formula cover the entire area of your "raw data" -- but I think you can see how the cell references can be enlarged. The reason I didn't extend it all the way had to do with your blank rows....anathema in many Excel applications....so I trust you'll be filling in those rows.
OK. Here's a working example (but, again, the FILTER function will only work if your Excel is the most up-to-date version).
Here's an image of the final result I'm seeing. The cells with color in the background are the only cells with formulas in them, the green one being the only one with FILTER in it; its results "spill" into adjacent cells as needed.
I didn't make the formula cover the entire area of your "raw data" -- but I think you can see how the cell references can be enlarged. The reason I didn't extend it all the way had to do with your blank rows....anathema in many Excel applications....so I trust you'll be filling in those rows.
