A Brief Guide to Excel IF, SUMIF and COUNTIF | Earn And Excel

A Brief Guide to Excel IF, SUMIF and COUNTIF | Earn And Excel

Excel is one of the blissful tools offered by Microsoft. Since Excel has been introduced to the world the finical, account, management and business domain have gained tremendous ease and benefits from the tool. Over a while with the changing demand of the industry, Excel has also adapted to the world and has always offered advance aid.

Having a strong hand in Excel is a must if, you are looking for a fabulous career opportunity in your future. The tool is the lifeline to many accounting and data analysis professionals.

Now, if you are eager to learn a few of the basic about excel, below, we are introducing some of the useful features of the software to satisfy your appetite:

Excel IF: Excel if is the function of logic. The tool is used to compare the values and find out if the given data stand true or false to the given statement.

The Excel IF function is specifically used for conditional statements. For example: say there is test conduct on a class of 20 students. The passing score is more the 50. Here a mark 50 is a condition to predict how many students have passed or failed the test. Hence in excel if we can implement this condition like: to “pass” scores above 50: = IF(A1>50, “Pass”, “Fail”).

One can implement more than one condition with if Function. The IF function can combine two logical functions like AND and OR e.g. =IF(C6>=50, “Pass”, “Fail”).

The syntax used for Excel IF is: =IF (logical_test, [value_if_true], [value_if_false])

Sum IF: The Excel SumIF function is a very useful tool to retrieve the sum of the cells in a particular range supported on supplied criteria. Here, the Criteria is the determining unit that describes which cell to be added.  Whereas the Range is the range of the cells that you wish to apply the Criteria against.

The syntax used for Sum IF function is =SUMIF (range, criteria, [sum_range]).

Here sum range is optional for the cells to add together. The logical operations supported by sum IF are >, <, <> and =.

For example:  in a sales company where 4 employees A, B, C, and D bring the sales of 100$, 120$, 50$ and 130$ respectively. Here you can apply the Criteria sales with operation greater than (>) to find out the total done over 50$. To the statement where:

Criteria are sales

The range is A to D

The total will be 350$.

Count IF: THE Count IF is one of the useful functions which are specifically used when you need to meet more than one criteria. The Count IF can be used for the Criteria like dates text, number, groups, and such other conditions. Like SumIF the function CountIF also support the logics <, >, <>, and =.

On counting the cells that match all the mentioned or multiple Criteria, the CountIF function result in a total number of times the Criteria have met.

The Syntax used for CountIF function is =COUNTIFS (range1, criteria1, [range2],[criteria2],….)

For easy and quick learning to become professional in all the function (Excel IF, SUMIF, COUNTIF, VLOOKUP) of Excel visit at https://earnandexcel.com now.

Leave a Reply