COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Adds up cell values based on a condition
|
|
|
Adds all the numbers in a range of cells
|
|
|
Returns a subtotal in a list or database
|
|
|
Both (a) & (b)
|
Detailed explanation-1: -Instead of adding up all numbers in a range, it lets you sum only those values that meet your criteria. So, whenever your task requires conditional sum in Excel, the SUMIF function is what you need. A good thing is that the function is available in all versions, from Excel 2000 through Excel 365.
Detailed explanation-2: -According to Microsoft Excel SUMIFS can be defined as a function that “Add the cells specified by a given set of conditions or criteria”. The syntax of the SUMIFS function is as follows: =SUMIFS(sum range, criteria range1, criteria1, [criteria range2, criteria2], …)
Detailed explanation-3: -The function is adding all numbers in a range of cells. The function will return the sum for the same.
Detailed explanation-4: -The SUMIF function in Excel is used to sum values based on a single condition or criteria. However, if we want to sum values based on multiple criteria where at least one of the conditions are met, we use the SUMIF with OR logic.