Excel SUMIF formula showing "0" in AppSheet

[imac]

I have the following formula in one column of my Excel table:
=SUMIF(Incm!H827:H1038, “<>y”, Incm!F827:F1038)

In the Excel sheet, the value shows correctly (eg. “2406”).
However, in AppSheet the value is shown as “0”, which is incorrect.

Does AppSheet allow me to use SUMIF formulas in my spreadsheet ?
If so, why is it not showing the calculation correctly ?
I am a completely new user and very grateful for any pointers in the right direction.

[WillowMobileSys]

AppSheet can detect when formulas are firing in your sheet and wait. Once done AppSheet picks up the results from your spreadsheet to show in the app. It doesn’t care about the formulas themselves only about the resulting value and if that value has changed.

To help with the zero value showing in Appsheet, we need to know about what you have down to create your AppSheet app and to display the value.

• What is the Table in AppSheet? A pic would help
• Which column is showing the unexpected value?
• What are the expressions for Initial Value and App Formula? A pic would help
• What View have you created? A pic would help
• What datasource for the View? If a slice, what columns and criteria? A pic would help

[1minManager]

Check that the Unpd[Unpaid] column in Appsheet is a Number, Decimal or Price type column

Try if the table is set to read only, you might have the update refresh option set at 24hrs

Simon@1minManager.com