This function returns sum of the given number.
E.X. =sum(2000,1500,6000,1000)
Answer: 10500
2. =SUMSQ()
This function is use to find out sum of the squire of given
number.
E.X. =sumsq(2,3,4)
Answer: 29
3. =SUMIF()
This function is use to display sum of the given number from a specified range those are fulfil our condition.
Answer: 300
E.X. =sum(2000,1500,6000,1000)
Answer: 10500
2. =SUMSQ()
This function is use to find out sum of the squire of given
number.
E.X. =sumsq(2,3,4)
Answer: 29
3. =SUMIF()
This function is use to display sum of the given number from a specified range those are fulfil our condition.
Answer: 300
4. =SUMIFS()
To sum cells based on multiple criteria (for example, blue and green), use the following SUMIFS function (first argument is the range to sum).
5. =COUNT()
This function is use to count only digit.
=count(3,5,9,S,6,F)
Answer: 4
6. =COUNTA()
This function is use to count all for a specified range.
=counta(3,5,9,S,6,S)
Answer: 6
7. =COUNTIF()
This function is use to count number for a specified range those are fulfil our condition.
Answer: 4
8. =COUNTIFS()
To count cells based on multiple criteria (for example, green and higher than 9), use the following COUNTIFS function.
0 Comments