SUMIFS help in Summary with column headers containing special chars

garcias76986

I'm trying to get the below SUMIFS to work but i'm getting #UNPARSEABLE.

=SUMIFS(Requested Amount (in Local Currency):Requested Amount (in Local Currency), Budget Owner*:Budget Owner*, "Tom MacKay", Approved:Approved, = 1)

The column names contain special characters, is that what is causing the problem? Or do I just have the syntax all wrong?

Stefan

Hello,

using special characters in the column titles is not a good idea.

Anyway, what you are missing is, that column titles in formulas always need to have square brackets around them, if they do not consist of one word.

So try:

=SUMIFS([Requested Amount (in Local Currency)]:[Requested Amount (in Local Currency)], [Budget Owner*]:[Budget Owner*], "Tom MacKay", Approved:Approved, = 1)

Hope this helps

Stefan

Stefan

Hello,

using special characters in the column titles is not a good idea.

Anyway, what you are missing is, that column titles in formulas always need to have square brackets around them, if they do not consist of one word.

So try:

=SUMIFS([Requested Amount (in Local Currency)]:[Requested Amount (in Local Currency)], [Budget Owner*]:[Budget Owner*], "Tom MacKay", Approved:Approved, = 1)

Hope this helps

Stefan

garcias76986

Stefan it was perfect!!! Thanks so much!!!