SUM Formulas
- Sum an Entire Column or a Row in Excel
- Sum Greater than Values using SUMIF
- Sum Not Equal Values (SUMIFS) in Excel
- Sum Only Visible Cells in Excel
- Sum Random Cells in Excel
- SUMIF / SUMIFS with an OR Logic in Excel
- SUMIF with Wildcard Characters in Excel
- SUMIFS Date Range (Sum Values Between Two Dates Array)
- Add a Total Row in Excel
- Combine VLOOKUP with SUMIF
- Sum IF Cell Contains a Specific Text (SUMIF Partial Text)
- Sum Values Based on Year (SUMIF Year)
- SUMIF By Date (Sum Values Based on a Date)
- SUMIF Non-Blank (Sum Values for Non-Empty Cells)
- Use SUMIF to Sum Blank Values or Empty Cells
- Quickly Use AutoSum in Excel
- Sum Values Less Than a Particular Value (SUMIF Less Than)
- Sum Values that are Greater than Zero (SUMIF)
- Using INDIRECT with SUM
- Sum Values Based on the Month (SUMIF)
- Running Total
- Sum Values by Group
COUNT Formulas
- Count Between Two Numbers (COUNTIFS) in Excel
- Count Blank (Empty) Cells using COUNTIF in Excel
- Count Cells Less than a Particular Value (COUNTIF) in Excel
- Count Cells Not Equal To in Excel (COUNTIF)
- Count Cells that are Not Blank in Excel
- Count Cells with Text in Excel
- Count Greater Than 0 (COUNTIF) in Excel
- Count Specific Characters in Excel
- Count Total Number of Cells from a Range in Excel
- Count Unique Values in Excel
- COUNT Vs. COUNTA
- Count Words in Excel
- OR Logic in COUNTIF/COUNIFS in Excel
- Count Filtered Rows in Excel
- Count Rows (All, Blank, Non-Blank, and with Numbers)
DATE Formulas
- Add Month to a Date in Excel
- Add Years to Date in Excel
- Add-Subtract Week from a Date in Excel
- Compare Two Dates in Excel
- Convert Date to Number in Excel
- Convert Text to Date in Excel
- Count Years Between Two Dates in Excel
- Create a Date Range in Excel
- Custom Date Formats in Excel
- DATEDIF Function in Excel
- Get Day Name from a Date in Excel
- Get Day Number of Year in Excel
- Get End of the Month Date in Excel
- Get First Day of the Month in Excel (Beginning of the Month)
- Get Month from a Date in Excel (Extract Month)
- Get Quarter from a Date [Fiscal + Calendar] in Excel
- Get Total Days in Month in Excel
- Get Years of Service in Excel
- Highlight Dates Between Two Dates in Excel
- Number of Months Between Two Dates in Excel
- Quickly Concatenate Two Dates in Excel
- Random Date Generator (Excel Formula) in Excel
- Years Between Dates in Excel
- Extract (Get) Year or Month from a Date in Excel
- Combine Date and Time in Excel
- Business Days in a Month
- Convert Date into a Text
- Countdown Days
- Convert Month Name to Number
- Count Days Between Two Dates (COUNTIF Date Range)
- Convert a Date into a Month and Year
- Convert to Julian Date
- Get Previous Sunday
TIME Formulas
- Add Hours to Time in Excel
- Add Minutes to Time in Excel
- Calculate Time Difference Between Two Times in Excel
- Change Time Format in Excel
- Military Time (Get and Subtract) in Excel
- Separate Date and Time in Excel
- Convert an Excel Time Value into a Decimal Number (Hours)
- Convert Minutes into Hours and Minutes (HH:MM)
- Convert Time Value into Minutes (Excel Formula)
- Convert Time Value into Seconds
- Get Current Time (Excel Formula)
- Sum Time in Excel (Excel Formula)
- Add Seconds to Time
- Convert Seconds to Hours and Minutes
- Time to Decimals
LOOKUP Formulas
- IFERROR with VLOOKUP in Excel to Replace #N/A in Excel
- Perform Two Way Lookup in Excel
- Reverse VLOOKUP (Backward: From Right to Left ) in Excel
- VLOOKUP MATCH Combination in Excel
- VLOOKUP with Multiple Criteria in Excel
- Wildcards with VLOOKUP in Excel
- VLOOKUP Dates (VLOOKUP for a Date from Data)
- Lookup for the Cell Address Instead of the Value
- Lookup Last Value from a Column or a Row
- VLOOKUP from Another Sheet (Between Sheets)
MATHS Formulas
- Average TOP 5 Values in Excel
- Calculate Compound Interest in Excel
- Calculate Cube Root in Excel
- Calculate Percentage Variance (Difference) in Excel
- Calculate Simple Interest in Excel
- Calculate SQUARE ROOT in Excel + Insert Symbol
- Calculate Weighted Average in Excel
- Calculate Coefficient of Variation (CV) in Excel
- Does Not Equal Operator in Excel
- MAX IF in Excel
- Quickly Calculate Ratio in Excel
- Round to Nearest .5, 5. 50 (Down-Up) in Excel
- Square a Number in Excel
- Round a Number to Nearest 1000 in Excel
- Add-Subtract Percentage from a Number
- Average But Ignore Errors (#N/A and Other Errors)
- Average Number but Exclude Zeros
- 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 Lowest Value from a List of Numbers (N)
- Find the Smallest Value from a Range of Cells (Smallest Number)
- Calculate Nth Root
- Get the Most Frequent Number(s) from an Array
- Round Percentage Values
CONDITIONAL 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 in Excel using SUMPRODUCT Function [RANKIF]
- IF Cell is Blank (Empty) using IF + ISBLANK in Excel
- IF Negative Then Zero (0) in Excel
- SUMPRODUCT IF to Create a Conditional Formula in Excel
- 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)
- SUBTOTAL with IF (Conditional SUBTOTAL)
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 in Excel
- Concatenate (Combine) a Range of Cells in Excel
- 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
- Remove Extra Spaces in Excel
- Separate Names in Excel – (First and Last Name)
- Count Characters in Excel (Cell and Range)
- Create a Dynamic Hyperlink
- Flip the First & Last Names and Add a Comma Between
- 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)
- Get the Domain from the Email ID
- Remove the Last Character from a String
- Remove Unwanted Characters
- Split a Text using a Space Between