Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Excel Pie Chart
  • Filter Data Based on Date in Excel
  • Subtotal function in Excel
  • Remove Duplicates Example in Excel
  • Conditional Formatting Rules in Excel

References

  • Two-column Lookup in Excel
  • How to get last row in mixed data with blanks in Excel
  • How to use Excel VLOOKUP Function
  • How to get last column number in range in Excel
  • How to get address of last cell in range in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation must begin with
  • Excel Data validation whole percentage only
  • Prevent invalid data entering in specific cells
  • Excel Data validation with conditional list

Tag: AGGREGATE function

How to Sum Range with Errors in Excel

by

This example shows you how to create an array formula that sums a range with errors. You can also use the AGGREGATE function to sum a range with errors. 1. We use the IFERROR function to check for an error. Explanation: the IFERROR function returns 0, if an error is found. If not, it returns the value of the cell. …

Continue Reading

Extract all partial matches in Excel

by

This tutorial shows how to Extract all partial matches in Excel using the example below; Formula =IF(F5>ct,””,INDEX(data,AGGREGATE(15,6,(ROW(data)-ROW($B$5)+1)/ISNUMBER(SEARCH(search,data)),F5))) Explanation To extract all matches based on a partial match, you can use use an array formula based on the INDEX and AGGREGATE functions, with support from ISNUMBER and SEARCH. In the example shown, the formula in G5 …

Continue Reading

How To Use AGGREGATE function to sum a range with errors in Excel

by

Excel functions such as SUM, COUNT, LARGE and MAX don’t work if a range includes errors. However, you can easily use the AGGREGATE function to fix this. 1. For example, Excel returns an error if you use the SUM function to sum a range with errors. 2. Use the AGGREGATE function to sum a range with errors. Explanation: …

Continue Reading

Average and ignore errors in Excel

by

This tutorial shows how to work Average and ignore errors in Excel using the example below; Formula =AVERAGEIF(values,”>=0″) Explanation To average a list of values, ignoring any errors that might exist in the range, you can use the AVERAGEIF or AGGREGATE function, as described below. In the example shown, the formula in E5 is: =AVERAGEIF(values,”>=0″) …

Continue Reading

Max value ignore all errors in Excel

by

This tutorial shows how to calculate Max value ignore all errors in Excel using the example below; Formula =AGGREGATE(4,6,values) Explanation To get the maximum value in numeric data while ignoring all errors, you can use the AGGREGATE function, as explained below. In the example shown, the formula in E5 is: =AGGREGATE(4,6,values) where “values” is the named …

Continue Reading

AGGREGATE function: Description, Usage, Syntax, Examples and Explanation

by

What is AGGREGATE function in Excel? AGGREGATE function is one of the Math and Trig functions in Microsoft Excel that returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values. Syntax of AGGREGATE function Reference …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel OR Function
  • Not Equal To ‘<>‘ operator in Excel
  • How to use IFS function in Excel
  • How to use Excel TRUE Function
  • Invoice status with nested if in Excel

Date Time

  • Assign points based on late time in Excel
  • Get work hours between dates custom schedule in Excel
  • TODAY function: Description, Usage, Syntax, Examples and Explanation
  • MINUTE function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Next working/business day in Excel

Grouping

  • Categorize text with keywords in Excel
  • Map text to numbers in Excel
  • How to randomly assign data to groups in Excel
  • How to randomly assign people to groups in Excel
  • Map inputs to arbitrary values in Excel

General

  • Check if multiple cells have same value in Excel
  • Index and match on multiple columns in Excel
  • Subtotal by invoice number in Excel
  • How to calculate percent sold in Excel
  • Check if multiple cells have same value with case sensitive in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning