Sumif for Balance Sheet

[Morayweb]

Hi folks.

I was looking for some guidance.

I have a ledger and balance sheet on gsheets.  I wondered what is the best way to tackle the sumif part.  eg if account is "events"  total up all entries that are events to give me a total on balance sheet, the same with other accounts.

Thank you

[Morayweb]

Hi Im a bit of a beginner but will have a go.  Where would this code go?

[Marc_Dillon · Accepted solution]

I think the advice from Guillermo here is completely off-base.

The basic equivalent of SUMIF in Appsheet is SUM(SELECT()). See their help articles here:

https://help.appsheet.com/en/articles/2357307-sum

https://help.appsheet.com/en/articles/2357314-select

As far as where to put the expression, read here:

https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values

And it will also be helpful to start learning about references between Tables, which may help you even more here, but is not 100% necessary to achieve what you're wanting.

https://help.appsheet.com/en/articles/961426-references-between-tables

[Guillermor16]

hola amigo, soy nuevo también en el uso de esta herramienta y agradezco todas las observación que me hagan, las cuales me sirven para aprender más, seguiré su recomendación. 

muchas gracias.

[Morayweb]

Thank you will study that looks more sensible.