Write cell with SUMIF Formula

Help
1

Hello Guys,

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

I’m trying to do that:

Untitled
Untitled810×1076 46 KB

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,
Diogo

2

Hi,

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.

1 Like