SUMIFS help in Summary with column headers containing special chars

Question

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 · Accepted Answer

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