Click Here to Drop Your Doubts
Summary: In this class, Jaywant Sir will be explaining how to do logical functions.
Process: Sum If: =sumif(Range, Criteria, [Sum Range])
Adds the cells specified by a given condition or criteria.
CountIF: =countif(Range, Criteria)
Counts the number of cells within a range that meet the given condition.
Average If =averageif(Range, Criteria, [Average Range])
Finds average for the cells specified by a given condition and criteria.
Conclusion: After completion of this class you will be able to do the following logical functions which are as follows: – Sum If, Count If, Average If.
