How To Use Sum And Count Function In Excel

Excel Sum and Count Function

Sum & Count functions are most frequently and commonly used functions of the Excel. We can even use these functions with multiple criteria by adding if condition with these functions.

Purpose:

Excel Sum function used to calculate the sum of total values which provided in the given range of cells or column.

Sum Function: 

Sum functions returns the sum of the all values which are in our provided range. Its having only one conditional criteria. In below shown example we have used sum formula and given range from A1:A6.

i.e. sum=(A1:A5) 

Excel Sum Function

Sumif Function :

Sumif functions returns the sum of the all values basis of one conditional criteria which are in our provided range. Its having one conditional criteria. In below shown example we have used sumif formula and given range from A1:A6 which having greater value then “8”. 

i.e. sumifs=(A1:A5,”>8″) 

sumif function 1

Sumifs Function :

Sumifs functions returns the sum of the all values basis of multiple conditional criteria which are in our provided range. Its having two or more conditional criteria. In below shown example we have used sumifs formula and given range from A1:A6 & B1:B6. Means it will calculate sum of A1:A6 where in B1:B6 range “blue” string mentioned. 

i.e. sumifs=(A1:A5,B1:B5,”blue”) 

sumifs function 1

Count Function:

Count function returns the count of the cells which having values (i.e. cell which are not empty)  from our provided range of cells. In below example we have used count formula and given range from A1:A5

i.e. count(A1:A5) which returns value 5.

Count Formula 1

Countif Function :

Countif function returns the count of the cells which having two criteria   from our provided range of cells. In below example we have used countif formula and given range from A1:A5 where value is greater (“>”) than 5

i.e. countif(A1:A5,”>5″) which returns value 4.

Countif Formula 1

Countifs Function:

Countifs function returns the count of the cells which having multiple criteria from our provided range of cells. In below example we have used countifs formula and given range from A1:A5 & B1:B5 where it will count A1:A5 cells on the basis of B1:B5 where Blue string mentioned.

i.e. countifs(A1:A5,”>5″,B1:B5,”Blue”) which returns value 1.

countifs formula 1

In short and simple words you can add if or ifs in front of Sum, Count, or Average formula to use these functions for two times or multiple criteria.

If you find this article useful and informative, please share the same with your friends and collogues.  Also comment in below comment box.

Abhijit

Abhijit currently working with India's No. 1 Ecommerce Company Flipkart. He having 6 years experience in Excel and he is also expertise in various Advance Excel formulas. He awarded by his organization for his outstanding contribution in Analytical Project.

Leave a Reply