
Explanation:
The SUIMIF function is a workbook function which based on one criterion, adds all the numbers in a set of cells (e.g., 2000). The SUMIF function is an optimized Excel function which is labeled as a Math / Trig function.
This method can be used in Excel as a WS function.