Formulas

Rev up your Excel skills with our massive collection of over 500 workings excel Formulas! This section is packed with detailed explanations, videos, and related links for each formula. You’ll master essential Formulas like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and many more.

Jump to Formulas

Count

FormulaRelated Functions
Count Between Two Numbers (COUNTIFS) in ExcelCOUNTIF
Count Blank (Empty) Cells using COUNTIF in ExcelCOUNTIF
Count Cells Less than a Particular Value (COUNTIF) in ExcelCOUNTIF, AVERAGEIF, SUMIF
Count Cells Not Equal To in Excel (COUNTIF)COUNTIF, COUNTIFS
Count Cells That Are Not Blank in ExcelCOUNTA, IF, ISBLANK, COUNTIF
Count Cells with Text in ExcelSUMPRODUCT, SUMIFS, EXACT
Count Filtered Rows in ExcelSUBTOTAL, COUNT, COUNTIF
Count Greater Than 0 (COUNTIF) in ExcelCOUNTIF
Count Specific Characters in ExcelCOUNTIF
Count Total Number of Cells from a Range in ExcelCOUNTA, COUNTIF
Count Unique Values in ExcelCOUNTIF, SUM
COUNT Vs. COUNTA
Count Words in ExcelSUBSTITUTE, LEN
OR Logic in COUNTIF/COUNIFS in Excel

Sum

Average

Dynamic Array

Min and Max

Lookup

If

Grouping

Conditional Formatting

Data Validation

Rank

Round

Date and Time

FormulaRelated Functions
Add Hours to Time in ExcelTIME
Add Minutes to Time in ExcelTIME
Add Month to a Date in ExcelEDATE
Get Day Number of Year in ExcelDATE, YEAR
Get Total Days in Month in ExcelEOMONTH, DATE, YEAR, MONTH

Text

Financial

Geometry

Workbook

Internet

Names

Percentage

Random

Range

Tables

Errors

Miscellaneous

Scroll to Top