Formula Error
HI,going to pull data from my mastersheet and bring it to the consolidated sheet and for this I've tried to use this formula, i'm keep getting this unpharseable error i didn't know what i did wrong, please help.
FORMULA - =SUMIFS({Order Value Sridhar Mastersheet}, {Sridhar Mastersheet Range 2,},"che",{Sridhar Mastersheet Range 3},"Production in process",{Sridhar Mastersheet Range 4}"<=01/10/2023",{Sridhar Mastersheet Range 4},"<=30/10/2023"))
Best Answer
-
Hey @vstr88889
Try this
=SUMIFS({Order Value Sridhar Mastersheet}, {Sridhar Mastersheet Range 2},"che", {Sridhar Mastersheet Range 3}, "Production in process", {Sridhar Mastersheet Range 4}, <=01/10/2023, {Sridhar Mastersheet Range 4},<=30/10/2023)
Will this work for you?
Kelly
Answers
-
Hey @vstr88889
Try this
=SUMIFS({Order Value Sridhar Mastersheet}, {Sridhar Mastersheet Range 2},"che", {Sridhar Mastersheet Range 3}, "Production in process", {Sridhar Mastersheet Range 4}, <=01/10/2023, {Sridhar Mastersheet Range 4},<=30/10/2023)
Will this work for you?
Kelly
-
Hi @vstr88889
I think these are the problems:
- You have more closing parentheses than opening ones. One of the end ones should be removed.
- The syntax around the last two criteria/range pairs is not correct. You need a comma between the range and the criterion.
- Putting the criterion in quotation marks means look for this text, which is what you need for the first two criteria but probably not what you want for the last 2, unless you are looking for a row that contains the text <=01/10/2023.
- If you are looking for rows with dates within a range, the date has to be entered in a DATE function otherwise it is interpreted as text. DATE(2023,10,1) not 01/20/2023
Try
=SUMIFS({Order Value Sridhar Mastersheet}, {Sridhar Mastersheet Range 2,}, "che", {Sridhar Mastersheet Range 3}, "Production in process", {Sridhar Mastersheet Range 4}, <=DATE(2023,10,1), {Sridhar Mastersheet Range 4}, <=DATE(2023,10,30))
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!