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)
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)
-
@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)
-
@Paul Newcome That worked!! thank you very much
-
happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!