Creating an inventory

BerryC

I have one sheet that is completed via a form. In the column Summer Shirt Issued, there are multiple options that must be selected. 2, women, X-Small. This indicated the number of shirts issued, the cut, and the size. I then want to reference this to my Current Women's Uniform Inventory sheet to deduct from the total number of Summer Shirts in size x-small on hand. I was using a countif, but I don't think I have it correct. I have the issued in 2024 and current stock as a child relationship to the starting stock on one sheet.

Sheet two below shows the information coming from the form

kowal

hi @BerryC,

I am not sure I fully got your problem but there seem to be more than one conditions to check so =countifs seems better to use.