DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SUMIFS
|
|
|
SUMIF
|
|
|
COUNTIF
|
|
|
SUBTOTAL
|
Detailed explanation-1: -The SUMIF function, also known as Excel conditional sum, is used to add up cell values based on a certain condition.
Detailed explanation-2: -You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula: =SUMIF(B2:B25, ">5")
Detailed explanation-3: -=SUMIF(range, criteria, [sum range]) The formula uses the following arguments: Range (required argument) – This is the range of cells that we want to apply the criteria against. Criteria (required argument) – This is the criteria which are used to determine which cells need to be added.
Detailed explanation-4: -The SUMIF formula returns the sum of cells based on one criterion (a result that matches one condition). Whereas, the SUMIFS function returns the sum of cells that meet multiple criteria. The criteria mentioned in both functions can be dates, numbers, and text.
Detailed explanation-5: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.