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.
Hi mathetes
Thank you for your response.
I'm a little confused as to how to use the "FILTER" function. I've tried to select the top "chicken with skin" item with an x in the first column. I'd like it to display the totals on the right hand side but I'm not sure how to get this function to work. I've watched the video, thanks.
Please see attached excel.
Any help would be much appreciated.
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.