How to include a logic statement with a sumif function?

[dbl_dbl]

I have a spreadsheet which constantly updates a table with data using a SUMIFS function. This function looks at both the product ID and the week it's in.

However, I would like to roll up all previous weeks into the current week's sumif, if possible.

In the attached spreadsheet, you can see we have apple sales in week 13 and bananas in week 14, but neither are captured. I don't mind if they are captured in a new row or if they are rolled into the top week (current week). I would just like to make sure it's captured on this table.

Thanks!

[Fluff13]

How about

Please Login or Register  to view this content.

[dbl_dbl]

That works nicely!

Can you explain how "<="& works? I can see that it's less than or equal to...am I able to use that logic test in any formula that's asking for criteria? What does the "&" do?

Thanks

[Fluff13]

The & concatenates the <= with the cell value giving you <=2019 15
You'd normally use something like that on numerical values, but it can also be used on text where it works on the "sort" order so Apples is < Oranges as it comes earlier in the sort oder