1. =SUM()
    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


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.