FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -To use SUMIF function, select the cell to display the result and follow the steps given below: 1 Click on the Math & Trig category in the Function Library group. 2 Select the SUMIF function from the displayed list of functions. Function Arguments dialog box appears.

Detailed explanation-2: -The SUMIF Function[1] is categorized under Excel Math and Trigonometry functions. It will sum up cells that meet the given criteria. The criteria are based on dates, numbers, and text. It supports logical operators such as (>, <, <>, =) and also wildcards (*, ?).

Detailed explanation-3: -The easiest way to apply the function is to simply select a cell next to the numbers that we wish to add and click on AutoSum on the Home tab. We can then press the Enter key and the SUM formula is automatically inserted.

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.

Detailed explanation-5: -Click the Formulas tab on the Ribbon. Click the More Functions button in the Function Library group of commands. Place the mouse pointer over the Statistical option from the drop-down list of options.