How to write formula to pull data from one sheet to other and sum based on specific criteria

Iznil76

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 :-)

Carson Penticuff

Here are a couple of different ways to format your formula:

=SUMIFS({LG Delivered in waste 12 months Range 3}, {LG Delivered in waste 12 months Range 1}, @cell <> 190606, {LG Delivered in waste 12 months Range 2}, @cell >= DATE(2024, 7, 1), {LG Delivered in waste 12 months Range 2}, @cell <= DATE(2024, 7, 31))

=SUMIFS({LG Delivered in waste 12 months Range 3}, {LG Delivered in waste 12 months Range 1}, @cell <> 190606, {LG Delivered in waste 12 months Range 2}, MONTH(@cell) = 7, {LG Delivered in waste 12 months Range 2}, YEAR(@cell) = 2024)

Carson Penticuff

Here are a couple of different ways to format your formula:

=SUMIFS({LG Delivered in waste 12 months Range 3}, {LG Delivered in waste 12 months Range 1}, @cell <> 190606, {LG Delivered in waste 12 months Range 2}, @cell >= DATE(2024, 7, 1), {LG Delivered in waste 12 months Range 2}, @cell <= DATE(2024, 7, 31))

=SUMIFS({LG Delivered in waste 12 months Range 3}, {LG Delivered in waste 12 months Range 1}, @cell <> 190606, {LG Delivered in waste 12 months Range 2}, MONTH(@cell) = 7, {LG Delivered in waste 12 months Range 2}, YEAR(@cell) = 2024)

Iznil76

Hi Carson, thank you so much! problem solved! :-D