Cross Sheet SUMIFS by date and name
I want to use a formula to get a sum of a weight from a list on a separate sheet that matches a certain name and has a ready date that falls within a certain month.
=SUMIFS({CFL & VL Product Stock List Range 1}, {CFL & VL Product Stock List Strain Name}, "Banana Baby", {CFL & VL Product Stock List Est. Ship Date}, "July 2022")
This above formula brings back a 0 but not the result I was looking for
=SUMIFS({CFL & VL Product Stock List Est Yield}, MONTH = 7, {CFL & VL Product Stock List Strain Name}, "Cold Creek Kush")
This above formula brings back #UNPARSEABLE
Any suggestions on what I am doing wrong?
Best Answer
-
My apologies. I missed a parenthesis.
=SUMIFS({CFL & VL Product Stock List Est Yield}, {CFL & VL Product Stock List Strain Name}, "Cold Creek Kush", {CFL & VL Product Stock List Est. Ship Date}, IFERROR(MONTH(@cell), 0) = 7)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
=SUMIFS({CFL & VL Product Stock List Est Yield}, {CFL & VL Product Stock List Strain Name}, "Cold Creek Kush", {CFL & VL Product Stock List Est. Ship Date}, "MONTH = 7")
Tried this but still bringing back a 0 where it should bring back over 150. Not sure where I am going wrong
-
Try this:
=SUMIFS({CFL & VL Product Stock List Est Yield}, {CFL & VL Product Stock List Strain Name}, "Cold Creek Kush", {CFL & VL Product Stock List Est. Ship Date}, IFERROR(MONTH(@cell, 0) = 7)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Getting error #INCORRECT ARGUMENT SET using the below formula
=SUMIFS({CFL & VL Product Stock List Est Yield}, {CFL & VL Product Stock List Strain Name}, "Cold Creek Kush", {CFL & VL Product Stock List Est. Ship Date}, IFERROR(MONTH(@cell, 0) = 7)
Any other ideas??
-
My apologies. I missed a parenthesis.
=SUMIFS({CFL & VL Product Stock List Est Yield}, {CFL & VL Product Stock List Strain Name}, "Cold Creek Kush", {CFL & VL Product Stock List Est. Ship Date}, IFERROR(MONTH(@cell), 0) = 7)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome That worked!! thank you very much
-
happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!