SUMIFS unparseable error

BrendaF

Hi all,

I'm trying to sum amounts in the Sub Total column if the Fiscal Year is 2024 and the Category is Internal. I get an unparseable error with this formula

Thanks for your help!

BrendaF

Well that's annoying — my formula didn't get saved in the question. This is it:

BrendaF

=SUMIFS[Sub Total]:[Sub Total],[Fiscal Year],2024,Category,"Internal"

Humashankar

Hi @BrendaF

Can you use square brackets around column names, regardless of whether they contain spaces or special characters.

=SUMIFS([Sub Total]:[Sub Total], [Fiscal Year]:[Fiscal Year], 2024, [Category]:[Category], "Internal")

Regards

BrendaF

Hi @Humashankar.

Thanks for your reply! I tried that, and now I get a Blocked error message.

Humashankar

Hi @BrendaF

Unparseable Error is due to syntax issues in the formula.

Blocked Error occurs due to access or permissions issues

Restricted column or sheet permissions.
Locked cells or columns when if they're protected or have restricted access.
Data validation conflicts or issues with specific cells.

You have to give it an approach from that angle for the new error.

Hope this helps !!