#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!

Find more posts tagged with

Accepted answers

Paul Newcome

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)))

All comments

bisaacs

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!

JConno

Hi @bisaacs ,

I have used the formula you suggested and I am seeing INCORRECT ARGUMENT SET…

Any ideas?

Thanks!

Paul Newcome

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)))

JConno

Hi @Paul Newcome

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!

Paul Newcome

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)))

JConno

Thanks @Paul Newcome !!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.