How to create a cumulative SUMIF?

Thank you for the quick responses guys... I don't think I explained my problem clearly enough so I have updated my example file. Essentially the idea is that I would like to know what my total sales of an individual product are up to a each date or sale... i.e. a cumulative total. The problem is that after a certain threshold of sales my cost goes down for that product and I want to reflect that in some other calculations so this cumulative total can tell me when in the year I hit that threshold.

Should be clearly demonstrated in the attached spreadsheet. Basically I am hoping that there is a variant of the SUMIF formula so that this cumulative total column can identify which product was sold and then what the total sales for that product were up to this particular date.

New example attached for clarity.

Thank you!!!

SUMIF Cumulative Calculation_2.xlsx

If some more clarity would help here is the last file with an additional example of how I thought this might work, but unfortunately it doesn't seem to stick.

SUMIF Cumulative Calculation_3.xlsx

Thanks for your replies guys. Fotis' solution worked. I needed to adjust the rows slightly but otherwise a good solution. A note that I found is you cannot use column references in your formula because for this particular formula you need to be more strict about which rows are included or not.

Hi Tom, I appreciate this post is old, but I was struggling to get my head around an array formula I was writing, this was perfect and the help I needed, thanks.