Home

Excel Formula Needed

%3CLINGO-SUB%20id%3D%22lingo-sub-719853%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719853%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20a%20spreadsheet%20which%20includes%204%20different%20meal%20options%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EManicotti%20Rosa%20(Vegetarian)%3A%20Three%20cheese%20filled%20manicotti%20with%20marinara%20and%20parmesan%20cheese%3C%2FP%3E%3CP%3ELondon%20Broil%20(Gluten%20Free)%3A%20Broiled%208oz%20marinated%20choice%20flank%20steak%20with%20mushroom%20wine%20sauce%3C%2FP%3E%3CP%3EChicken%20Breast%20Supreme%20(Gluten%20Free)%3A%206oz%20boneless%20chicken%20breast%20with%20mushroom%20supreme%20sauce%3C%2FP%3E%3CP%3EAtlantic%20Salmon%20(Gluten%20Free)%3A%208oz%20salmon%20filet%20with%20lemon%20tarragaon%20hollandaise%20sauce%20with%20honey%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20total%20of%20how%20many%20of%20each%20meal%20is%20needed.%20None%20of%20the%20formulas%20I%20have%20tried%20work.%20What%20formula%20would%20I%20need%20to%20use%20and%20how%20would%20I%20create%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-719853%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719891%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719891%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366313%22%20target%3D%22_blank%22%3E%40EricaS19%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20may%20need%20some%20clarification.%20What%20do%20you%20mean%20by%20%22you%3CSPAN%3E%26nbsp%3Bneed%20a%20total%20of%20how%20many%20of%20each%20meal%20is%20needed%3C%2FSPAN%3E%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719892%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20needed%20to%20know%20how%20many%20people%20ordered%20the%20London%20Broil%2C%20how%20many%20ordered%20the%20Salmon%2C%20etc.%20but%20I%20got%20the%20formula%20to%20work.%20So%20problem%20solved!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719893%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719893%22%20slang%3D%22en-US%22%3EOkay%20great!%3C%2FLINGO-BODY%3E
EricaS19
New Contributor

I am working on a spreadsheet which includes 4 different meal options:

 

Manicotti Rosa (Vegetarian): Three cheese filled manicotti with marinara and parmesan cheese

London Broil (Gluten Free): Broiled 8oz marinated choice flank steak with mushroom wine sauce

Chicken Breast Supreme (Gluten Free): 6oz boneless chicken breast with mushroom supreme sauce

Atlantic Salmon (Gluten Free): 8oz salmon filet with lemon tarragaon hollandaise sauce with honey

 

I need a total of how many of each meal is needed. None of the formulas I have tried work. What formula would I need to use and how would I create it?

3 Replies

Hello @EricaS19,

 

I may need some clarification. What do you mean by "you need a total of how many of each meal is needed"?

 

Thanks,

PReagan

Highlighted

@PReagan 

I needed to know how many people ordered the London Broil, how many ordered the Salmon, etc. but I got the formula to work. So problem solved!

Okay great!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies