SUMIF Formula MS Excel / How to use SUMIF Function in MS Excel.

Excel SUMIF Formula / SUMIF Function in Microsoft Excel / How to use SUMIF with Example in Excel Worksheet. SUMIF Formula Syntax Excel.

SUMIF is a very powerful formula in MS Excel. The use of SUMIF is very high in Companies. SUMIF is not so tough as it looks like. It's a very easy to use and important formula in Excel. Every Excel use should have knowledge about SUMIF Function. SUMIF Formula works in all MS Excel Versions like MS Office 2003, 2007, 2010 etc. Here we use SUMIF Formula with Example.

The SUM Formula in Excel simply count two or more values, but if an excel users wants the sum of a specific value in a specific range then SUMIF formula will be used. So, how to use SUMIF Formula / Function in Excel? Here we will learn SUMIF formula with example.

What is the Syntax of SUMIF and How to use SUMIF Formula in Excel Spreadsheet?

SUMIF Formula / Syntax:- =SUMIF(range, criteria, [sum_range]).

Range:- Cells range to be evaluated.

Criteria:- the condition or criteria which will be in the form of a number, expression, or text that defines which cells will be added.

sum_range:- the actual cells to sum.

SUMIF Sample Data

NOTE:- If sum_range ommited(leave blank) the cells in the range are used as sum_range.

SUMIF formula Example:-

Suppose we have a data of salespersons, target, total sale, and status for target achieve or not, now if

we have to calculate the total sale of those salespersons who had achieved their target then we will use SUMIF formula, below is SUMIF Example:-

Here we want to sum of the total sale for those salespersons who had completed their targets (those whose total sale value is greater than 600 rs.).

SUMIF Formula with Example

Here is the result for those salesperson who have completed for their targets 8199 rs (Sum of Total sales of the salesperson those who have total sale greater than 600).

In the above formula:-

Range is D2:D21

Criteria is D2

Sum_Range:-C2:C21

Read More

SUM Formula with example in MS Excel / Excel SUM Formula

SUM Formula with Example in MS Excel / MS Excel SUM Function / Difference between SUM & SUMIF formula / Function in Microsoft Excel.

In Microsoft Excel SUM Function or Formula is a very useful formula or function. With the help of SUM Formula in MS Excel Excel users can calculate / find the SUM of given Numbers. SUM Formula works in all MS Excel Versions like MS Office 2003, 2007, 2010 etc. Here we use SUM Formula with Example.

The SUM formula does exactly what you would expect or want. SUM formula allows you to add 2 or more numbers together very quickly and in a very simple way. You can use cell references (Give values from cells) as well in SUM formula.

What is the SUM Formula in MS Excel?

Formula:- =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5

Now here we add two numbers and numbers with cell reference in excel. You can use Excel as a calculator for mathematical functions. SUM is an example of mathematical functions.
Lets say you have two values and want to add both the values just type =SUM(value1, value2, .......valueN) and you will get the summation of the values / numbers. Instead of entering values or numbers in the formula you can also give cell references if you have data in your Excel Sheet / Table cells and you want to add those numbers / values.

Excel SUM Formula with Example

Instead of typing SUM Formula you can simply adding two or more values by putting + sign between two or more values in MS Excel worksheet or Excel Table after = equal to sign.

There is a another SUMIF Formula / Function in Excel. SUMIF is little different from SUM.

What is the Difference between SUM & SUMIF formula?

There is little difference between SUM & SUMIF Formula in Excel. In SUM Formula you don't need to give any range or range criteria, it adds simply numbers as given. In SUMIF Formula you can give a specific range, criteria you want. SUMIF formula adds the cells specified by given condition and criteria. SUMIF Formula:- =SUMIF(range, criteria, [sum_range]).

To Know Excel Shortcuts CLICK HERE.

Read More

Numeric/Mathematical Function

Numeric/Mathematic Function-
To know the average value of numbers provided. Average called also arithmetic mean	AVERAGE	=AVERAGE(Number1, Number2, ...Number_n)
To count the number of cell that contains numbers.	COUNT	=COUNT(argument1, argument2, ....argument_n) *argument1, argument2..argument_n can be the ranges or cells or values.
To count the number of cells in a given criteria.	COUNTIF	=COUNTIF(range, criteria)
To count the number of cells in single or multiple criteria.	COUNTIFS	=COUNTIFS(critaria1_range, criteria1, critaria2_range, critaria2,...critaria_n_range, critaria_n)
To find the reminder after a number is devided by a divisor.	MOD	=MOD(numbner, divisor)
To add all numbers in a range of cells.	SUM	=SUM(cell1:cell2, cell3:cell4,...) OR =SUM(number1, number2,...number_n)
To add all numbers in a range of cells based on given criteria.	SUMIF	=SUMIF(range, criteria, [sum_range]) *sum_range is optional(if it is blank function uses range as the sum_range)

Read More