DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
sumif
|
|
|
countif
|
|
|
if
|
|
|
average
|
Detailed explanation-1: -Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
Detailed explanation-2: -The difference between COUNTIF and COUNTIFS is that COUNTIF is designed for counting cells with a single condition in one range, whereas COUNTIFS can evaluate different criteria in the same or different ranges. When doing financial analysis, COUNTIF helps in doing a quick analysis.
Detailed explanation-3: -The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
Detailed explanation-4: -Using COUNTIFS to Count Between two Numbers First, enter the “=COUNTIS(“ in cell C1. After that, refer to the range from where you want to count the values. Next, you need to specify the upper number using greater than and equal sign. From here, again you need to refer to the range of numbers in the criteria2.