AppSheet SumIFS (Excel formula)

[Pedroarango11]

Hi all, this has been asked many times but I can’t seem to do it

So I have a table where people record the following information:

name (selected from ref to another table) - Labor (selected from another table - Amount of clamshells harvested (#) - hours (#). I need to find the average number of clamshells harvested per hour by each employee and average number of clamshells packed by each employee.

Here is the formula where I Sumed the total values of clamshells of each person, but dont know how to separate by labor

[Vincent_P]

hi,

just another column avg with [cosechado por empleado] / [# de horas], no ?

this is a groupby in view on labor and empleado where u see the avg you want.