User Profile
Kathy_j2290
Copper Contributor
Joined Feb 21, 2022
User Widgets
Recent Discussions
- 3.3KViews0likes0Comments
- 3.4KViews0likes4Comments
sumifs formula
I run a commercial kitchen. I have set up a spreadsheet using sumifs to bring in required information. I am stuck on one formula. I want the sumif to read and match a cell in the worksheet then use several criteria in the data. for example, match cell a3 (which has the name of the meal e.g lemon chicken) sort through data in another tab and sum the quantity for "hot" lemon chicken. The data is in columns with meal names, temperature, quantities. For some reason I cant work out where to put the reference cell for it to match the information to. I don't want to write "lemon Chicken" into the formula because I need to make the spreadsheet dummy proof for staff that cant use excel so I need them to choose a meal name in the cell it is referencing.Solved4KViews0likes9Comments
Recent Blog Articles
No content to show