COUNTIFS AND SUMIFS (EXCEL)

What is the syntax for the SUMIFS function in Excel?

• a. =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)
• b. =SUMIF(sum_range, criteria_range, criteria)
• c. =SUMIF(range, criteria)
• d. =SUM(range)

What is the purpose of the SUMIFS function?

• a. To count the number of cells that meet one or more criteria
• b. To sum the values in a range that meet one or more criteria
• c. To find the average of values in a range that meet one or more criteria
• d. To lookup a value in a table based on one or more criteria

What is the syntax for the COUNTIFS function in Excel?

• a. =COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2, ...)
• b. =COUNTIF(range, criteria)
• c. =COUNT(range)
• d. =COUNTIF(criteria_range, criteria)

What is the purpose of the COUNTIFS function?

• a. To sum the values in a range that meet one or more criteria
• b. To count the number of cells that meet one or more criteria
• c. To find the average of values in a range that meet one or more criteria
• d. To lookup a value in a table based on one or more criteria

In the SUMIFS function, what is the purpose of the sum_range argument?

• a. To specify the range of cells to be summed
• b. To specify the criteria range
• c. To specify the criteria
• d. None of the above

In the SUMIFS function, how many criteria ranges and criteria can be specified?

• a. One criteria range and one criteria
• b. One criteria range and multiple criteria
• c. Multiple criteria ranges and one criteria
• d. Multiple criteria ranges and multiple criteria

What is the maximum number of criteria ranges and criteria that can be used in a single SUMIFS formula in Excel?

• 10
• 120
• 125
• 127

What formula would you use to calculate the total salary of all employees in the table?

• a. =SUM(Salary)
• b. =SUMIF(Salary, ">=0")
• c. =SUMIFS(Salary, Salary, ">=0")
• d. =SUMIFS(Salary, Salary, ">0")

What formula would you use to calculate the total salary of employees with IDs 001 and 002?

• a. =SUMIF(Employee ID, {"001", "002"}, Salary)

• b. =SUMIFS(Salary, Employee ID, {"001", "002"})

• c. =SUMIF(Employee ID, "001", Salary) + SUMIF(Employee ID, "002", Salary)

• d. =SUMIFS(Salary, Employee ID, "001", Salary, "002")

count the number of sales made in the region "West" for the product "Product A"

• =COUNTIFS(B2:B7,"Product A",A2:A7,"West"

• =COUNTIFS("Product A",B2:B7,"West"

• =COUNTIF(A2:A7,"Product A",B2:B7,"West"

• =COUNTIFS\(A2:A7,"Product A",B2:B7,"West"