Write cell with SUMIF Formula


#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:

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.


#3