**Contents**show

## 1. SUM Formulas

- SUMIF / SUMIFS with an OR Logic in Excel
- SUMIFS Date Range (Sum Values Between Two Dates) in Excel
- SUMIF with Wildcard Characters in Excel
- Sum an Entire Column or a Row in Excel
- Sum Greater than Values using SUMIF in Excel
- Sum Not Equal Values (SUMIFS) in Excel
- Sum Random Cells in Excel
- Sum Only Visible Cells in Excel
- Use SIF to Sum Blank Values or Empty Cells in Excel
- Sum IF Cell Contains a Specific Text (SUMIF Partial Text) in Excel
- SUMIF By Date (Sum Values Based on a Date) in Excel
- SUMIF Non-Blank (Sum Values for Non-Empty Cells) in Excel
- Combine VLOOKUP with SUMIF in Excel
- Sum Values Based on Year (SUMIF Year) in Excel

- Add a Total Row in Excel
- AutoSum in Excel
- Sum Values that are Greater than Zero (SUMIF) in Excel
- Sum Values Less Than a Particular Value (SUMIF Less Than) in Excel
- Using INDIRECT with SUM in Excel
- Sum Values Based on the Month (SUMIF) in Excel
- Running Total in Excel
- Sum Values by Group in Excel
- Sum of Squares in Excel

## 2. COUNT Formulas

- OR Logic in COUNTIF/COUNIFS in Excel
- Count Words in Excel
- Count Greater Than 0 (COUNTIF) in Excel
- Count Between Two Numbers (COUNTIFS) in Excel
- Count Cells Not Equal to in Excel (COUNTIF)
- Count Total Number of Cells from a Range in Excel
- Count Blank (Empty) Cells using COUNTIF in Excel
- Count Cells Less than a Particular Value (COUNTIF) in Excel
- Count Specific Characters in Excel
- Count Cells with Text in Excel

## 3. DATE Formulas

- Convert Text to Date in Excel
- DATEDIF in Excel
- Custom Date Formats in Excel
- Get Month from a Date in Excel (Extract Month) in Excel
- 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
- 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

- 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
- Get First Day of the Month in Excel (Beginning of Month) in Excel
- 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
- Add Month to a Date in Excel
- Quickly Concatenate Two Dates in Excel
- Random Date Generator (Excel Formula) in Excel

## 4. TIME Formulas

## 5. LOOKUP Formulas

## 6. MATHS Formulas

- Calculate 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
- 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
- Divide in Excel

- Average Only Non-Blank Cells
- Calculate Average of the Percentage Values
- Calculate the Average of the Time Values
- Calculate the Cumulative Sum of Values (Excel Formula)
- Find the Smallest Value from a Range of Cells (Smallest)
- Find the Lowest Value from a List of Numbers (N)
- Get the Most Frequent Number(s) from an Array
- Calculate Nth Root
- Round Percentage Values
- Add-Subtract Percentage from a Number
- Average But Ignore Errors (#N/A and Other Errors)
- Average Number but Exclude Zeros

## 7. CONDITIONS Formulas

- Check IF 0 (Zero) Then Blank in Excel
- Check IF a Value Exists in a Range in Excel
- Combine IF and AND Functions in Excel
- Combine IF and OR Functions in Excel
- Compare Two Cells in Excel
- Conditional Ranking [RANKIF]
- IF Cell is Blank (Empty) using IF + ISBLANK
- SUBTOTAL with IF (Conditional SUBTOTAL)
- Greater Than (>) and Equal To (=) Operator

- IF Negative Then Zero (0) in Excel
- SUMPRODUCT IF – Conditional Formula
- Check IF a Cell Contains a Partial Text
- Check IF a Cell Value is a Number
- If a Cell Value Starts with a Text or a Number
- Median with IF (Conditional Criteria)
- CONCATENATE IF (Combine with Condition)
- TRUE and FALSE in Excel (Boolean Values)
- Arithmetic Operators in Excel

## 8. TEXT Formulas

- Add New Line in a Cell in Excel (Line Break)
- Add Leading Zeros in Excel
- Capitalize First Letter in Excel
- Change Column to Row (Vice Versa) in Excel
- Change to Sentence Case in Excel
- Concatenate (Combine) Cells with a Comma
- Concatenate (Combine) a Range of Cells
- Concatenate with a Line Break in Excel
- Create a Horizontal Filter in Excel
- Create a Star Rating Template in Excel
- Get File Name in Excel
- Get Sheet Name in Excel
- Remove First Character from a Cell in Excel
- Quickly Generate Random Letters in Excel
- Randomize a List (Random Sort) in Excel
- Get the Domain from the Email ID
- Remove the Last Character from a String
- Remove Unwanted Characters
- Extract Text After and Before a Character
- Wildcard Characters in Excel

- Remove Extra Spaces in Excel
- Separate Names in Excel – (First & Last Name)
- Count Characters in Excel (Cell and Range)
- Create a Dynamic Hyperlink
- Flip First & Last Names & Add a Comma
- Get File Path (Excel Formula)
- Get the Value from a Cell
- Extract Last Word from a Cell
- Remove Line Break from a Cell
- Remove Parentheses in Excel (Brackets)
- Substitute Multiple Values (Nested)
- Generate Random Groups
- Add Space (Single and Multiple)
- Add Commas (Cell-Text)
- Compare Two Strings (Text)
- Split a Text using a Space Between
- Change Text Case (Upper, Lower, Proper)
- Extract Only Numbers from a Text (String)
- Remove Commas