Latest Post

4/recent/ticker-posts

USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE



In this Excel post we describe Math Category Formulas Sum, Sumif & Sumifs use with Example. So pleas read carefully.




USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE
  

SUM

Sum Formula in excel we add two or more numeric cells.

Syntax

SUM(number1, number2 ...)

number1 - The first item that you want to add.

number2 - The second item that you want to add. 

Example - In this Sheet Sum of Items Qty =Sum(B2:B4) then press enter you result is 28 display. means 5+8+15 = 28. 

USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE


Use of Count, Counta, Countblank, Countif and Countifs with Example

SUMIF

SUMIF function use to conditionally sum the values which match the given single criteria.

Syntax


SUMIF(range, criteria, [sum_range])
range - The range of cells that you want evaluated by criteria.

criteria - The criteria in the form of a number, expression, a cell reference, text, or a function that defines which cells will be added.

sum_range - The actual cells to add, if you want to add cells other than those specified in the range argument. 

Example - In this Sheet we want John total sales so apply this formula =Sumif(A2:A10,"John",C2:C10) and press enter, here result display 18943, means John total sales is in this sheet 18943. 

USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE



Microsoft Excel Easy Notes for Beginners


SUMIFS


SUMIFS is used to conditionally sum the values which match the two or more multiple criteria.

Syntax


SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

sum_range - One or more cells to sum, including numbers or names. 


criteria_range1 - The first range in which to evaluate the associated criteria. 



criteria1 - The criteria in the form of a number, expression, cell reference, or text that define which cells in the criteria_range1 argument will be added. 



criteria_range2, criteria2- Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed. 


Example - In this Sheet we want two conditions John total sales in South Region so apply this formula - =Sumifs(C2:C10,B2:B10,"South", A2:A10,"John") 
and press enter, here result display 11312, means John total sales in South Region is 11312.

USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS WITH EXAMPLE



Conclusion 

I hope you understanding Use of Math Category Formulas Sum, Sumif & Sumifs. If any question related this post pleas ask and comment. 

एक टिप्पणी भेजें

0 टिप्पणियाँ