SOLVED

Is it possible to select multiple options (which each have multiple associated values) and sum them.

%3CLINGO-SUB%20id%3D%22lingo-sub-2036316%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20select%20multiple%20options%20(which%20each%20have%20multiple%20associated%20values)%20and%20sum%20them.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2036316%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20create%20a%20meal%20plan%20with%20excel.%20I've%20used%20excel%20to%20calculate%20the%20protein%2C%20carbs%2C%20calories%20and%20fat%20for%20the%20amount%20of%20grams%20of%20that%20item.%20For%20example%2C%20rice%20100g%20gives%20350%20kcal%208%20protein%200.5%20fat%20and%2078%20carbs.%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20select%20multiple%20items%20like%20check%20or%20tick%20the%20ones%20I%20want%2C%20eg%20rice%2C%20chicken%2C%20etc%20and%20then%20add%20them%20to%20a%20meal%20plan%20which%20has%20separate%20columns.%20I'm%20using%20excel%20online.%20Is%20this%20possible%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20image%20attached%20for%20an%20idea%20of%20what%20I%20mean.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EYDN10%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2036316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2036373%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20select%20multiple%20options%20(which%20each%20have%20multiple%20associated%20values)%20and%20sum%20t%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2036373%22%20slang%3D%22en-US%22%3EFrom%20looking%20online%2C%20it%20looks%20like%20checklists%20are%20possible%20but%20only%20in%20normal%20excel%20not%20excel%20online.%20I'm%20still%20looking%20if%20it's%20possible%20to%20select%20multiple%20cells%20and%20add%20them%20to%20a%20separate%20row%20(i.e.%20the%20meal%20plan%20row)%20which%20I%20can%20then%20add%20up%20to%20get%20my%20totals.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2036407%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20select%20multiple%20options%20(which%20each%20have%20multiple%20associated%20values)%20and%20sum%20t%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2036407%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F919811%22%20target%3D%22_blank%22%3E%40YDN10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20Excel%20online%20accept%20the%20new%20FILTER%20function%3F%20If%20it%20does%2C%20it%20would%20be%20easy%20to%20simply%20add%20a%20column%20where%20you%20enter%20an%20%22x%22%20(or%20whatever)%2C%20and%20then%20have%20FILTER%20display%20those%20items%20that%20have%20been%20marked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFILTER%20is%20a%20new%20function%20in%20Microsoft%20365%20subscriptions%2C%20a%20very%20powerful%20function....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20YouTube%20video%20that%20explains%20FILTER%20(as%20well%20as%20a%20few%20other%20new%20and%20useful%20functions.%20Maybe%20it'll%20motivate%20you%20to%20get%20the%20full%20system.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(For%20future%20reference%2C%20you%20make%20it%20easier%20for%20us%20to%20help%20you%20if%20you%20post%20the%20actual%20spreadsheet%20rather%20than%20an%20image.%20)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2036566%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20select%20multiple%20options%20(which%20each%20have%20multiple%20associated%20values)%20and%20sum%20t%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2036566%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response.%3C%2FP%3E%3CP%3EI'm%20a%20little%20confused%20as%20to%20how%20to%20use%20the%20%22FILTER%22%20function.%20I've%20tried%20to%20select%20the%20top%20%22chicken%20with%20skin%22%20item%20with%20an%20x%20in%20the%20first%20column.%20I'd%20like%20it%20to%20display%20the%20totals%20on%20the%20right%20hand%20side%20but%20I'm%20not%20sure%20how%20to%20get%20this%20function%20to%20work.%20I've%20watched%20the%20video%2C%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I'd like to create a meal plan with excel. I've used excel to calculate the protein, carbs, calories and fat for the amount of grams of that item. For example, rice 100g gives 350 kcal 8 protein 0.5 fat and 78 carbs. 

I'd like to select multiple items like check or tick the ones I want, eg rice, chicken, etc and then add them to a meal plan which has separate columns. I'm using excel online. Is this possible? 

 

Please see image attached for an idea of what I mean.

 

Any help would be greatly appreciated.

 

Thanks

 

Kind regards,

YDN10

6 Replies
From looking online, it looks like checklists are possible but only in normal excel not excel online. I'm still looking if it's possible to select multiple cells and add them to a separate row (i.e. the meal plan row) which I can then add up to get my totals.

@YDN10 

 

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. )

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...

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.

 

Best Response confirmed by YDN10 (Occasional Contributor)
Solution

@YDN10 

 

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.

mathetes_0-1609947850329.png

 

Thank you very much @mathetes ! I really appreciate it!!

 

Kind regards,

 

YDN10