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.
Table of Contents
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)
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″)
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”)
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.
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.
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.
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.
