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
Formula | Related Functions |
Count Between Two Numbers (COUNTIFS) in Excel | COUNTIF |
Count Blank (Empty) Cells using COUNTIF in Excel | COUNTIF |
Count Cells Less than a Particular Value (COUNTIF) in Excel | COUNTIF, AVERAGEIF, SUMIF |
Count Cells Not Equal To in Excel (COUNTIF) | COUNTIF, COUNTIFS |
Count Cells That Are Not Blank in Excel | COUNTA, IF, ISBLANK, COUNTIF |
Count Cells with Text in Excel | SUMPRODUCT, SUMIFS, EXACT |
Count Filtered Rows in Excel | SUBTOTAL, COUNT, COUNTIF |
Count Greater Than 0 (COUNTIF) in Excel | COUNTIF |
Count Specific Characters in Excel | COUNTIF |
Count Total Number of Cells from a Range in Excel | COUNTA, COUNTIF |
Count Unique Values in Excel | COUNTIF, SUM |
COUNT Vs. COUNTA | |
Count Words in Excel | SUBSTITUTE, LEN |
OR Logic in COUNTIF/COUNIFS in Excel | |
Sum
Average
Dynamic Array
Min and Max
Lookup
If
Grouping
Data Validation
Rank
Round
Date and Time
Text
Financial
Geometry
Workbook
Internet
Names
Percentage
Random
Range
Tables
Errors
Miscellaneous