appsheet shows #value for my spreadsheet formula

[SyM_Delarbel]

Hi. I have the following 2 formulas in my xl sheet: 

=SUMIF(Citas!$D:$D,Clientes!C2,Citas!$AI:$AI)

=SUMIF(Citas!$B:$B,Contabilidad!A2,Citas!$AH:$AH)

Both of them are working well in the xl sheet, but on the AppSheet the first one works well, but the second one returns #VALUE.

Could anyone help me with that issue?

[Tommy62]

Wie lauten deine AppSheet Ausdrücke dafür???

[SyM_Delarbel]

For the first one, the one working well in AppSheet, this is the generated expression : SUMIF(Citas!C4:C4,Clientes!RC[-15],Citas!C35:C35)

For the second one, The one that returns #VALUE, this is the generated expression : SUMIF(Citas!C2:C2,Contabilidad!RC[-1],Citas!C34:C34)