Excel Functions Reference
Clear, example-first reference pages for the Excel functions people actually use. Each page has the syntax, worked examples, the errors that bite most often, and whether it works the same in Google Sheets.
New printable reference
Open cheat sheet Excel Cheat Sheet: shortcuts + formulas
Search 71 Windows and Mac shortcuts, copy 19 essential formulas, or download the free one-page PDF and practice workbook.
Most used
Lookup
4 functions- VLOOKUPLooks up a value in the first column of a range and returns a value from a column to its right in the same row.
- XLOOKUPThe modern replacement for VLOOKUP and HLOOKUP. Searches any array and returns a matching value from another array, in any direction.
- INDEXReturns the value at a given row (and optional column) position within a range.
- MATCHReturns the position of a value within a range, rather than the value itself.
Logic
2 functionsMath
7 functions- SUMIFAdds the cells in a range that meet a single condition.
- SUMIFSAdds cells that meet multiple conditions across several ranges.
- COUNTIFCounts the cells in a range that meet a single condition.
- COUNTIFSCounts cells that meet multiple conditions across several ranges.
- SUMAdds all the numbers in one or more ranges.
- AVERAGEReturns the arithmetic mean of the numbers in a range.
- AVERAGEIFAverages the cells in a range that meet a condition.
Text
4 functions- TEXTJOINJoins text from multiple cells or a range with a delimiter, optionally skipping blanks.
- CONCAT & the & operatorJoins text from several cells or literal strings into one value.
- LEFT, RIGHT & MIDExtract a fixed number of characters from the start, end, or middle of a text value.
- TRIMRemoves leading, trailing, and repeated internal spaces from text.
Date
2 functionsNeed the formula written for you?
Describe what you want in plain English and get the formula instantly - free, no signup, and it runs in your browser.