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