DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNTIF
|
|
|
DCOUNT
|
|
|
SUMIF
|
|
|
COUNT
|
Detailed explanation-1: -The SUMIF function, also known as Excel conditional sum, is used to add up cell values based on a certain condition. The function is available in Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and lower.
Detailed explanation-2: -The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.
Detailed explanation-3: -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-4: -For example, the formula =SUMIF(B2:B5, “John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal “John.” To sum cells based on multiple criteria, see SUMIFS function.
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.