Lectures List
capscom technology computer course almora

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)
Author/Written by: Mr Hemant Singh (Founder)
Terms & Conditions CAPSCOM TECHNOLOGY Pvt. Ltd. का बेहतर रूप से संचालन करने के लिए यहॉ कुछ नियमें और शर्ते लागू है अगर आप कैप्सकॉम टैक्नोलॉजी में पढ़ रहे है तो यह आप पर लागू होता है।