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.
Does Excel online accept the new FILTER function? If it does, it would be easy to simply add a column where you enter an "x" (or whatever), and then have FILTER display those items that have been marked.
FILTER is a new function in Microsoft 365 subscriptions, a very powerful function....
Here's a YouTube video that explains FILTER (as well as a few other new and useful functions. Maybe it'll motivate you to get the full system. https://www.youtube.com/watch?v=9I9DtFOVPIg
(For future reference, you make it easier for us to help you if you post the actual spreadsheet rather than an image. )
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.