Replicating SUMIFS logic is possible in EasyMorph but the exact realization depends on whether the criteria ranges are in the same table or not. In your case they are in the same table, so the SUMIFS formula can be replicated with one “Calculate new column” action and one “Aggregate” action.
It’s not clear what the filtering criteria are in your example, so I can’t tell exactly how replicate it in EasyMorph. Below is a sample EasyMorph project that does the same filtering as in the SUMIFS example from the MS Office help: SUMIFS function.
sumifs.morph (4.0 KB)
Book1.xlsx (9.8 KB)
The calculation logic is as follows:
- Produce a column that contains only values that match the filtering criteria.
- Aggregate that column
In this example, a new column is calculated using the expression below:
when(startswith([Product], "A") and [Salesperson] = "Tom", [Quantity Sold])
See also the help topic on the when() function: http://help.easymorph.com/doku.php?id=syntax:functions:when