#UNPARSEABLE ERROR MESSAGE
Is anybody able to advise as to why I am getting an error message using my formula:
=SUMIFS({Business Unit}, [Business Unit]@row, {Plane Travel Distance}, AND, ({Date of Upload}, @cell >= DATE(2024, 1, 1), {Date of Upload}, @cell <=DATE(2024, 12, 31)))
Thanks!
Best Answer
-
Sorry about that. I saw the issue with the AND syntax and missed the syntax issue before that:
=SUMIFS({Plane Travel Distance}, {Business Unit}, [Business Unit]@row, {Date of Upload}, AND(@cell >= DATE(2024, 1, 1), @cell <=DATE(2024, 12, 31)))
Answers
-
Hey @JConno,
Looks like you need to remove the comma after the AND word:
=SUMIFS({Business Unit}, [Business Unit]@row, {Plane Travel Distance}, AND({Date of Upload}, @cell >= DATE(2024, 1, 1), {Date of Upload}, @cell <=DATE(2024, 12, 31)))
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Hi @bisaacs ,
I have used the formula you suggested and I am seeing INCORRECT ARGUMENT SET…
Any ideas?
Thanks!
-
The syntax is a bit off. Try this instead:
=SUMIFS({Business Unit}, [Business Unit]@row, {Plane Travel Distance}, {Date of Upload}, AND(@cell >= DATE(2024, 1, 1), @cell <=DATE(2024, 12, 31)))
-
Thank you for coming in to support!
I still have an error message as above.
I am trying to calculate from a master sheet the amount of KMs travelled by a particular business unit between 1st January 2024 and 31st December 2024.
Any thoughts?
Thanks!
-
Sorry about that. I saw the issue with the AND syntax and missed the syntax issue before that:
=SUMIFS({Plane Travel Distance}, {Business Unit}, [Business Unit]@row, {Date of Upload}, AND(@cell >= DATE(2024, 1, 1), @cell <=DATE(2024, 12, 31)))
-
Thanks @Paul Newcome !!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!