Answer :
Explanation:
- Click the Math & Trig button on the formula page, in the library category function.
- Click SUMIF
- In the range argument box, type category
- In the criteria box, type "office expense"
- In the sum range argument box, type cost
- Click ok
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.