Looking for alternative for SUMIFS()

[Marcel_Duon_Blo]

Hello. I used the SUMIFS() formula in my excel spreadsheet and everything works fine but there is a long delay sometimes to compute the result. So I want to add a virtual column to replace it in Appsheet to make offline calculation. Is there a function in Appsheet equivalent to SUMIFS() ?
Thank you

[Marc_Dillon · Accepted solution]

SUM( SELECT(…) )

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Marcel_Duon_Blo]

Thank you Marc_Dillion for your help, I’m reading the article

[Marcel_Duon_Blo]

I read the article but it doesn’t work for me

[Marcel_Duon_Blo]

I have three tables. First table that records sales, Second records purchases and the last on which I want to display the total amount of sales and that of purchases. A sale can be made by different sellers, and it is the same for a purchase. In the end, I want to get the total sales and total purchases for each seller

[Marcel_Duon_Blo]

This is what I want to replace with virtual columns.
Tot. Encaissements is in a table
Tot. Décaissements is in another table

I used SUMIFS() formula in excel to get this resultat perfectly, but now I don’t know what formula I can use to do the same with virtual columns. I tried with SELECT() but no way. Maybe I don’t use it correctly

[Marc_Dillon]

What expression did you try?

[Marcel_Duon_Blo]

I tried this. I’ve two criteria. I mean two different values in the column N° Compte : 1 and 2.
SUM(SELECT(Encaissements[Total], ([N° Compte] = 1)))

[Marcel_Duon_Blo]

I would like to thank you @Marc_Dillon for your help and your attention. I used the SELECT () function and got the expected result. It is sure that I did not use it well. But now it works perfectly in the virtual column. Thank you so much. God bless you

This is the expression

SUM(SELECT(Encaissements[Total],
[N° Compte] = [_THISROW].[N° Compte]
))

[Steve]

Well done!