Which Excel^® function allows you to count using more than one criterion? A) COUNTIF B) COUNTIFS C) SUMPRODUCT D) VLOOKUP E) HLOOKUP

Question

Quizplus · Accepted Answer

The COUNTIFS function in Excel allows you to count using multiple criteria, whereas the COUNTIF function only allows you to count using one criterion. SUMPRODUCT is a function used for multiplication and addition of arrays of numbers, while VLOOKUP and HLOOKUP are used to search for a specific value in a table and return a corresponding value from an adjacent cell. Therefore, the best choice for counting using multiple criteria in Excel is the COUNTIFS function.

Which Excel® Function Allows You to Count Using More Than

Which Excel^® Function Allows You to Count Using More Than