School Menu / Inventory Tracking

M

MadDvlDg

New Member
Joined
Jul 24, 2013
Messages
6
Hello all,

I am looking for a way to automatically add up the qty of an item that has been used in sheet "MENU" on the "Inventory" Sheet.

I have 2 sheets:

Sheet 1: Inventory
ITEMQTYUSEDREMAINING
CHIPS100Sum From "Menu"=QTY-USED
CAPRISUN200Sum From "Menu"=QTY-USED
MUFFINS230Sum From "Menu"=QTY-USED
POPTARTS420Sum From "Menu"=QTY-USED

<tbody>
</tbody>

Sheet 2: Menu
menu.png

Any help would be greatly appreciated.

<tbody>
</tbody>
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
maybe something like....


Excel 2012
ABCDEFGHIJK
1MondayTuesdayWednesdayThursdayFriday
2Item25-Aug26-Aug27-Aug28-Aug29-Aug
3BreakfastWaffles2Toast2Cereal1Lunchable1Muffins1
4Main LunchPB&J1Ham1Lunchable1Turkey1PB&J1
5Snack 1Carrots5Raspberries5Apple1Grapes5AppleSauce1
6Snack 1 2Gold Fish1Fruit Snack1Peanuts1Chips1Popcorn1
7DrinkWater1Caprisun1Water1Gatorade1Caprisun1
8
9
10ItemQTYUSEDRemaining
11Chips100199
12Caprisun2002198
13Muffins2301229
14Poptarts4200420
15Gold Fish514
16Lunchable523

<tbody>
</tbody>
Menu​

Worksheet Formulas
CellFormula
C11=SUMIF(Menu!$B$3:$J$7,A11,Menu!$C$3:$K$7)
D11=B11-C11

<tbody>
</tbody>

<tbody>
</tbody>
 
Upvote 0
Weazel said:
maybe something like....


Excel 2012
ABCDEFGHIJK
1MondayTuesdayWednesdayThursdayFriday
2Item25-Aug26-Aug27-Aug28-Aug29-Aug
3BreakfastWaffles2Toast2Cereal1Lunchable1Muffins1
4Main LunchPB&J1Ham1Lunchable1Turkey1PB&J1
5Snack 1Carrots5Raspberries5Apple1Grapes5AppleSauce1
6Snack 1 2Gold Fish1Fruit Snack1Peanuts1Chips1Popcorn1
7DrinkWater1Caprisun1Water1Gatorade1Caprisun1
8
9
10ItemQTYUSEDRemaining
11Chips100199
12Caprisun2002198
13Muffins2301229
14Poptarts4200420
15Gold Fish514
16Lunchable523

<tbody>
</tbody>
Menu​

Worksheet Formulas
CellFormula
C11=SUMIF(Menu!$B$3:$J$7,A11,Menu!$C$3:$K$7)
D11=B11-C11

<tbody>
</tbody>

<tbody>
</tbody>
Click to expand...

That seemed to do the trick. Thank you very much.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Formula for subtracting from a total, if a specific item is selected from a dropdown
2
Replies
13
Views
223
mumps
mumps
M
  • Question
Year over year counts
Replies
3
Views
254
RobP
R
O
  • Solved
Save PDF's from a dropdown menu using VBA
2
Replies
12
Views
424
ob1tech77
O
C
  • Question
Stock inventory - count unique sequences from barcode
Replies
0
Views
387
ChemistryBMS
C
M
  • Solved
remained balance for ID based on textbox on userform
Replies
2
Views
170
Maklil
M

Forum statistics

Threads
1,215,479
Messages
6,125,041
Members
449,206
Latest member
Healthydogs

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top