How to write formula to pull data from one sheet to other and sum based on specific criteria
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 :-)
Best Answer
-
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)
Answers
-
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)
-
Hi Carson, thank you so much! problem solved! :-D
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!