डिप्लोमा इन ऑफिस मैनेजमेंट एण्ड अकाउटिंग

डिप्लोमा इन ऑफिस मैनेजमेंट एण्ड अकाउटिंग

Full Stack Web Development with Laravel

Full Stack Web Development with Laravel

Affiliate Program

Affiliate Program

MS Excel Basic functions

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)
© 2016 - 2023, All Rights are Reserved.