I have created my inventory list.
I would like to track current inventory.
I have 4 different sheets that track the quantity of promo items going out. (Programs, Other Events, Donations, Sales)
As well as an additional sheet for Inventory Received (INQTY).
I have named all 5 Quantity columns by using the define name option. Names are: INQTY, OUTQTY1, OUTQTY2, OUTQTY3, OUTQTY4.
I understand using this formula =SUMIF(INOUTCODE,C4,INQTY) will work with 1 colmn of data but HOW DO I write the formula to include all 5 columns of data (INQTY, OUTQTY1, OUTQTY2, OUTQTY3, OUTQTY4)?
Any help would be greatly appreciated.
Thank you!
Bookmarks