Excel Formulas [Examples]

Average

Count

By using the COUNTIF function:

By using the COUNTBLANK function:

Date

Days in month

Restrict date to be entered and cell should only accept desired date (e.g Friday only)

Min & Max

Larger of two values

Minimum value from a set of values.

nth largest value

Round

Round a number

SUM

by using SUM function:

By using SUMIFS function:

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved