DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
COUNTIF
|
|
|
SUMIF
|
|
|
AVERAGEIF
|
|
|
None of the above
|
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 first step is to specify the location of the numbers: =SUMIFS(D2:D11, In other words, you want the formula to sum numbers in that column if they meet the conditions. That cell range is the first argument in this formula-the first piece of data that the function requires as input.
Detailed explanation-3: -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.