Excel Function Reference
Complete guide to essential Excel functions. Learn syntax, see examples, and master the most powerful spreadsheet functions.
Lookup Formulas Functions
View categoryVLOOKUP
Learn how to use VLOOKUP in Excel to search for values in a table. Includes syntax, examples, common errors, and tips fo...
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])XLOOKUP
Master XLOOKUP, Excel's modern lookup function. Learn syntax, examples, and why XLOOKUP replaces VLOOKUP for more flexib...
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])INDEX-MATCH
Learn the INDEX-MATCH formula combination in Excel. More flexible than VLOOKUP, it allows lookups in any direction with ...
INDEX(array, MATCH(lookup_value, lookup_array, [match_type]))Math Formulas Functions
View categorySUMIF
Learn SUMIF to sum cells based on criteria. Master single-condition summing with text, numbers, dates, and wildcards....
SUMIF(range, criteria, [sum_range])SUMIFS
Master SUMIFS for summing with multiple conditions. Learn to combine criteria for powerful conditional calculations....
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)COUNTIF
Learn COUNTIF to count cells meeting specific criteria. Count text, numbers, dates, blanks, and use wildcards....
COUNTIF(range, criteria)SUMPRODUCT
Master SUMPRODUCT for weighted sums, conditional calculations, and array operations. A powerful alternative to SUMIFS....
SUMPRODUCT(array1, [array2], [array3], ...)Logical Formulas Functions
View categoryIF
Master the IF function for conditional logic in Excel. Learn syntax, nested IFs, combining with AND/OR, and practical ex...
IF(logical_test, value_if_true, [value_if_false])IFERROR
Learn IFERROR to catch and handle formula errors gracefully. Replace #N/A, #VALUE!, #DIV/0! and other errors with custom...
IFERROR(value, value_if_error)Text Formulas Functions
View categoryDate & Time Formulas Functions
View categoryDATE
Learn the DATE function to create dates from year, month, and day values. Essential for date calculations and dynamic da...
DATE(year, month, day)DATEDIF
Master DATEDIF to calculate differences between dates in years, months, or days. Perfect for age calculations and tenure...
DATEDIF(start_date, end_date, unit)Array Formulas Functions
View categoryFILTER
Learn the FILTER function for dynamic array filtering in Excel 365. Create auto-updating filtered lists without helper c...
FILTER(array, include, [if_empty])SORT
Master the SORT function for dynamic array sorting in Excel 365. Sort data automatically without manual sort operations....
SORT(array, [sort_index], [sort_order], [by_col])UNIQUE
Learn UNIQUE to extract distinct values from a range. Create dynamic lists without duplicates that update automatically....
UNIQUE(array, [by_col], [exactly_once])Can't Find the Right Function?
Describe what you want to calculate in plain English and our AI will suggest the best function and generate the formula for you.
Try AI Formula Generator