You can easily emulate the Excel SUMIF() function using a few transforms.
For example to sum only commission on properties worth >160,000 here:
| Property Value | Commission |
|---|---|
| 100000 | 7000 |
| 200000 | 14000 |
| 300000 | 21000 |
| 400000 | 28000 |
sumif.transform (2.5 KB)
1 Like