#UNPARSEABLE ERROR MESSAGE

JConno

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!

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

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. 👍️