Sumif Total sale In Date range

[First_Yo]

Appsheet doesn’t support auto compute for sumif on googlesheet formula.

googlesheet formula : =SUMIF(Sale!$E2:$E,">="&Sale!$J$1,Sale!$H2:$H)

2 column [Sale Date] & [Total Payout]

How to make this compute on appsheet?
I want it to sum all the numbers in 1/1/2020-12/30/2020.