DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Count the number of cells based on one criteria
|
|
Sumif
|
|
|
Productif
|
|
|
Averageif
|
|
|
Countif
|
Explanation:
Detailed explanation-1: -COUNTIF uses only a single criteria. Use COUNTIFS if you want to use multiple criteria.
Detailed explanation-2: -To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function.
There is 1 question to complete.