Enter a formula in the selected cell using SUMIF to calculate the total expenses for the category Office Expense. Use the range

Question

3 years ago

7

Enter a formula in the selected cell using SUMIF to calculate the total expenses for the category Office Expense. Use the range

name Category for the Range argument, the text string "Office Expense" for the Criteria argument, and Cost for the Sum_range argument. Font Size

Business

2 answers:

yaroslaw [1] · Answer 1 · 2022-02-20T08:29:24+03:00

yaroslaw [1]3 years ago

6 0

Answer:

your mom

Explanation:

Agata [3.3K] · Answer 2 · 2022-02-20T07:25:02+03:00

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.