Function Name |
Description |
Example |
sum(range) |
Return sum of values from the range |
=sum(A1: A10) |
sumif(range, criteria) |
Return sum of values from the range after satisfying condition |
=sumif(A1: A10, ">1000") |
average(range) |
Return average of values from the range |
=average(A1 : A10) |
averageif(range, criteria) |
Return average of values from the range after satisfying condition |
=averageif(A1 : A10, ">1000") |
count(range) |
Return count of all the items from the given range |
=count(A1: A10) |
countif(range, criteria) |
Return count of all the items from the given range after satisfying condition |
=countif(A1: A10, ">1000") |
max(range) |
Return maximum value from the given range |
=max(A1: A10) |
min(range) |
Return minimum value from the given range |
=min(A1 : A10) |