Excel Functions & Formulas
How to Use HLOOKUP with IF Condition in Excel (3 Examples)
Learn how to use HLOOKUP with IF in Excel through examples, including bonus conditions, IFERROR for invalid data, and nested IF rules.
Read article
Excel Functions & Formulas
69 articles
Excel Functions & Formulas
Excel VLOOKUP to Auto-Transfer Data Between Excel Sheets
Learn how to transfer data between Excel worksheets automatically using VLOOKUP, XLOOKUP, or INDEX-MATCH for flexible and accurate lookups.
Read article
Excel Functions & Formulas
Vlookup from Multiple Columns with Only One Return in Excel
Learn how to VLOOKUP from multiple columns in Excel with one return using a helper column, XLOOKUP, or the INDEX-MATCH formula.
Read article
Excel Functions & Formulas
How to Use AVERAGEIF with Greater Than 0 Condition in Excel
Learn how to use AVERAGEIF in Excel with greater than 0 criteria to calculate averages for numbers, ranges, text matches & date conditions.
Read article
Excel Functions & Formulas
How to Use COUNTIF Function to Calculate Percentage in Excel
Learn how to use COUNTIF in Excel to calculate percentages for text, numeric thresholds, completion rates, and non-blank responses easily.
Read article
Excel Functions & Formulas
Excel COUNTIFS Function with 7 Advanced Practical Examples
Learn advanced Excel COUNTIFS techniques to count data by date ranges, partial matches, OR logic, exclusions, and structured references.
Read article
Excel Functions & Formulas
How to Rank Data in Excel with Sorting (5 Useful Methods)
Learn how to rank data in Excel with sorting using SORT, RANK, INDEX, and MATCH functions, plus VBA for automatic ranking and tie-breaking.
Read article
Excel Functions & Formulas
How to Use SUMIFS with Date Range by Month in Excel
Learn how to use SUMIF in Excel with a date range by month using SUMIFS, EDATE, and EOMONTH functions for dynamic & accurate monthly totals.
Read article
Excel Functions & Formulas
How to Use SUMIF with Not Equal to Condition in Excel
Learn how to use SUMIF in Excel with a not equal to condition to exclude values, skip blanks, apply wildcards, and handle multiple criteria.
Read article
Excel Functions & Formulas
SUMIFS with Multiple Criteria across Columns and Rows in Excel
Learn how to use SUMIFS in Excel with multiple criteria across columns and rows, including date ranges, wildcards, and numeric conditions.
Read article
Excel Functions & Formulas
How to Sum If Greater Than and Less Than a Cell Value in Excel
Learn how to use SUMIF and SUMIFS in Excel to sum values greater than, less than, or between cell values using dynamic ranges & references.
Read article
Excel Functions & Formulas
How to Do Ranking in Excel Based on Multiple Criteria
Learn how to do ranking in Excel based on multiple criteria using RANK, COUNTIFS, SUMPRODUCT, and techniques for unique and grouped rankings.
Read article