Hi All, I am trying to pull data from one sheet to another and the data will be a sum of weights from one column, without those rows that contain code 190606, and the dates are only for the month of July 2024. The formula I have so far is below, but that returns an answer of 0 which is incorrect:
=SUMIFS({LG Delivered in waste 12 months Range 3}, {LG Delivered in waste 12 months Range 1}, “<>190606”, {LG Delivered in waste 12 months Range 2}, “>=1/7/2024”, {LG Delivered in waste 12 months Range 2}, “<=31/7/2024”)
Would anyone be able to point me in th right direction please?
many thanks 🙂