Hello! New member i'm using the inventory management spreadsheet from here for about 5 months. I'm tracking about 80 different items we manufacture. I'm trying to get a usage report for most/all of the 80 different products. I want to see how many of a given item is used in a month. For instance, we produce a item, DD03-GE7. I want to be able to go to my reports sheet and see how many DD03-GE7 we use a month. I have a transaction log with the item #, date sold and qty sold. I am using a SUMIFS formula:

=SUMIFS(H:H,G:G,"DD03-GE7",F:F,">="&E1,F:F,"<="&EOMONTH(E1,0))

This returns a '0' value. We do have a number of transactions for the DD03-GE7 so i'm not sure why it returns '0'. In my transaction log, 'stock out' is noted with a '-5' while 'stock in' is noted with a '5'. I think it is the negative number that is causing the problem. I've attached the sheet in question. At the bottom of this file is where i am working on this formula. How do i deal with negative numbers in this formula?