200+ Excel Formulas List (Basic + Advanced)
1. SUM Formulas
- Use SUMIF to Sum Blank Values or Empty Cells
- Sum IF Cell Contains a Specific Text (SUMIF Partial Text)
- SUMIF By Date (Sum Values Based on a Date)
- SUMIF Non-Blank (Sum Values for Non-Empty Cells)
- Combine VLOOKUP with SUMIF
- Sum Values Based on Year (SUMIF Year)
- Add a Total Row in Excel
- Quickly Use AutoSum in Excel
2. COUNT Formulas
3. DATE Formulas
- Convert Text to Date in Excel
- DATEDIF Function in Excel
- Custom Date Formats in Excel
- Get Month from a Date in Excel (Extract Month)
- Get End of the Month Date in Excel
- Get Total Days in Month in Excel
- Get Day Name from a Date in Excel
- Highlight Dates Between Two Dates in Excel
- Get Quarter from a Date [Fiscal + Calendar] in Excel
- Add Years to Date in Excel
- Add-Subtract Week from a Date in Excel
- Get Day Number of Year in Excel
- Create a Date Range in Excel
- Compare Two Dates in Excel
- Convert Date to Number in Excel
- Count Years Between Two Dates in Excel
- Get Years of Service in Excel
- Add Month to a Date in Excel
- Quickly Concatenate Two Dates in Excel
- Random Date Generator (Excel Formula) in Excel
- Get First Day of the Month in Excel (Beginning of the Month)
- Number of Months Between Two Dates in Excel
- Years Between Dates in Excel
- Combine Date and Time in Excel
- Extract (Get) Year or Month from a Date in Excel
- Count Days Between Two Dates (COUNTIF Date Range) in Excel
- Convert Month Name to Number in Excel
- Business Days in a Month in Excel
- Convert Date into a Text in Excel
- Countdown Days in Excel
- Convert to Julian Date in Excel
- Convert a Date into a Month and Year in Excel
- Get Previous Sunday in Excel
4. TIME Formulas
5. LOOKUP Formulas
6. MATHS Formulas
- Weighted Average in Excel
- Quickly Calculate Ratio in Excel
- MAX IF in Excel
- Average TOP 5 Values in Excel
- Calculate Square Root in Excel + Insert Symbol in Excel
- Round to Nearest .5, 5. 50 (Down-Up) in Excel
- Calculate Cube Root in Excel
- Round a Number to Nearest 1000 in Excel
- Calculate Percentage Variance (Difference) in Excel
- Square a Number in Excel
- Calculate Coefficient of Variation (CV) in Excel
- Does Not Equal Operator in Excel
- Average Number but Exclude Zeros
- Average But Ignore Errors in Excel
- Average Only Non-Blank Cells in Excel
- Average of the Percentage Values in Excel
- Average of the Time Values in Excel
- Calculate the Cumulative Sum of Values in Excel
- Find the Smallest Value from a Range of Cells (Smallest Number) in Excel
- Find the Lowest Value from a List of Numbers (N) in Excel
- Get the Most Frequent Number(s) from an Array in Excel
- Calculate Nth Root in Excel
- Round Percentage Values in Excel
- Add-Subtract Percentage from a Number in Excel
- Perform Divide in Excel
- Get Max Date from a List of Dates in Excel
7. CONDITIONAL Formulas
- SUMPRODUCT IF to Create a Conditional Formula in Excel
- Combine IF and OR Functions in Excel
- Combine IF and AND Functions in Excel
- Conditional Ranking in Excel using SUMPRODUCT Function [RANKIF]
- IF Negative Then Zero (0) in Excel
- Check IF a Value Exists in a Range in Excel
- Check IF 0 (Zero) Then Blank in Excel
- Compare Two Cells in Excel
- Check IF a Cell Contains a Partial Text
- Median with IF (Conditional Criteria)
- Check IF a Cell Value is a Number
- If a Cell Value Starts with a Text or a Number
- SUBTOTAL with IF (Conditional SUBTOTAL)
- CONCATENATE IF (Combine with Condition)
- Arithmetic Operators in Excel
- IF Cell is Blank (Empty) using IF + ISBLANK in Excel
8. TEXT Formulas
- Change to Sentence Case in Excel
- Create a Star Rating Template in Excel
- Add Leading Zeros in Excel
- Remove Extra Spaces in Excel
- Remove First Character from a Cell in Excel
- Quickly Generate Random Letters in Excel
- Separate Names in Excel – (First and Last Name)
- Concatenate (Combine) a Range of Cells in Excel
- Concatenate with a Line Break in Excel
- Capitalize the First Letter in Excel
- Get Sheet Name in Excel
- Concatenate (Combine) Cells with a Comma in Excel
- Get the File Name in Excel
- Change Column to Row (Vice Versa) in Excel
- Randomize a List (Random Sort) in Excel
- Create a Horizontal Filter in Excel
- Add New Line in a Cell in Excel (Line Break) in Excel
- Count Characters in Excel (Cell and Range)
- Extract Last Word from a Cell
- Remove Line Break from a Cell
- Remove Parentheses in Excel (Brackets)
- Get the Value from a Cell
- Flip the First and last Names and Add a Comma Between
- Create a Dynamic Hyperlink in Excel
- Get File Path (Excel Formula)
- Add Commas (Cell-Text) in Excel
- Generate Random Groups
- Split a Text using a Space Between
- Remove Unwanted Characters
- Add Space (Single and Multiple) in Excel
- Substitute Multiple Values (Nested) in Excel
- Compare Two Strings (Text)
- Get the Domain from the Email ID
- Remove the Last Character from a String
- Change Text Case (Upper, Lower, Proper)
- Extract Text After and Before a Character in Excel
- Extract Only Numbers from a Text (String)
- Remove Commas