Write cell with SUMIF Formula


Hello Guys,

I have a issue when i’m trying to Write a formula in a specific cell.

I’m trying to do that:

Additionally, i already used with the separator (Instead “,” with “;”) and the error that appear is the last screenshot.

With the normal SUM formula it works fine.

Thank you for your help.

Best Regards,



Since the formula will have embedded strings inside the string, you will need to embed quotes.
You can basically just do that by doubling the quotes.
For example,

"=SUMIF(A1:A5,""""3rd Party OtherCtry"""" ...)

Hope that helps. Regards.