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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies