Why I get $#VALUE!

HI. I’m just a beginner.
I have a SUMIF() formula in my xl sheet adding values from other sheets. It works well adding them, but in my app it shows $#VALUE! instead of the actual value.
Any idea?

What is the column type in the data table in AppSheet?

1 Like