FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Click the Formulas tab on the Ribbon. Click the Math & Trig button in the Function Library group of commands (see Figure 3.25 “Selecting the COUNTIF Function from the Function Library"). Select the SUMIF function from the drop-down list. Use the scroll bar to scroll down to find the SUMIF function.

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.