Spreadsheet Functions A-Z Reference
Master the complete catalog of core Excel and Google Sheets functions with syntax blueprints, argument breakdowns, and practical use cases.
AVERAGEIFS Function in Excel & Google Sheets (Conditional Averages)
Calculate average values meeting multiple conditions, date thresholds, and category filters using AVERAGEIFS in spreadsheets.
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...]) COUNTIFS Function in Excel & Google Sheets (Count with Multiple Criteria)
Count rows meeting multiple criteria across dates, categories, and numeric comparisons using COUNTIFS in Excel and Google Sheets.
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2, ...]) DATEDIF Function in Excel & Google Sheets (Calculate Time Elapsed)
Calculate exact years, months, and days elapsed between two dates using the DATEDIF formula in Excel and Google Sheets.
=DATEDIF(start_date, end_date, unit) EDATE & EOMONTH Functions in Excel & Google Sheets (Add Months & End of Month)
Calculate future contract renewal dates, subscription expirations, and monthly fiscal milestones using EDATE and EOMONTH in spreadsheets.
=EDATE(start_date, months) | =EOMONTH(start_date, months) FILTER Function in Excel & Google Sheets (Dynamic Array Filtering)
Master the dynamic array FILTER function in Excel and Google Sheets. Filter ranges by single, multiple, and complex AND/OR criteria.
=FILTER(array, include, [if_empty]) Google Sheets ARRAYFORMULA: Apply Formulas to Entire Columns Automatically
Master ARRAYFORMULA in Google Sheets to apply math, text logic, and lookups to thousands of rows automatically without dragging formulas down.
=ARRAYFORMULA(IF(A2:A="", "", B2:B * C2:C)) Google Sheets GOOGLEFINANCE Function: Real-Time Stocks, Forex & Crypto
Fetch live stock prices, currency exchange rates, historical daily prices, and financial market metrics in real time using GOOGLEFINANCE.
=GOOGLEFINANCE("NASDAQ:AAPL", "price") | =GOOGLEFINANCE("CURRENCY:USDEUR") Google Sheets IMPORTRANGE Function: Link & Sync Data Across Sheets
Link separate Google Sheets workbooks together in real time using the IMPORTRANGE function, combined with QUERY and FILTER.
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/SPREADSHEET_ID", "Sheet1!A1:Z100") Google Sheets QUERY Function: SQL-Like Data Analysis (Complete Guide)
Master the Google Sheets QUERY function. Run SQL-like SELECT, WHERE, GROUP BY, PIVOT, and ORDER BY queries directly on your spreadsheet data.
=QUERY(data_range, "SELECT A, B, SUM(D) WHERE C = 'Closed Won' GROUP BY A, B ORDER BY SUM(D) DESC label SUM(D) 'Total Revenue'", 1) IF Function in Excel & Google Sheets (Logical Conditions & Nested IFs)
Master the IF function in Excel and Google Sheets. Learn single condition tests, nested IF statements, and combining IF with AND / OR.
=IF(logical_test, value_if_true, [value_if_false]) IFERROR Function in Excel & Google Sheets (Trap & Replace Errors)
Catch and replace #N/A, #VALUE!, #DIV/0!, #REF!, and #NAME? errors with custom text, zero, or blank cells using IFERROR and IFNA.
=IFERROR(value, value_if_error) IFS Function in Excel & Google Sheets (Multiple Conditions Without Nesting)
Replace messy nested IF statements with the clean, readable IFS function in Excel and Google Sheets.
=IFS(condition1, value1, [condition2, value2, ...], [TRUE, default_value]) INDEX & MATCH Formula in Excel & Google Sheets (Complete Guide)
Master the classic INDEX and MATCH combo for dynamic 2-way lookups, left lookups, case-sensitive searches, and multi-criteria lookups.
=INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) LAMBDA Function in Excel & Google Sheets (Create Custom Reusable Functions)
Build custom, reusable spreadsheet functions without VBA, macros, or Apps Script using the LAMBDA formula in Excel and Google Sheets.
=LAMBDA([parameter1, ...], calculation)(value1, ...) LET Function in Excel & Google Sheets (Variables in Spreadsheet Formulas)
Assign names to calculation results, eliminate redundant formulas, and boost spreadsheet performance with the LET function.
=LET(name1, value1, [name2, value2, ...], calculation) NETWORKDAYS & NETWORKDAYS.INTL in Excel & Google Sheets (Working Days)
Calculate working business days between two dates, excluding weekends and custom holidays, using NETWORKDAYS.INTL in spreadsheets.
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) SEQUENCE Function in Excel & Google Sheets (Generate Sequential Numbers)
Generate dynamic series of numbers, dates, times, and 2D number grids using the SEQUENCE array formula in Excel and Google Sheets.
=SEQUENCE(rows, [columns], [start], [step]) SORT & SORTBY Functions in Excel & Google Sheets (Dynamic Array Sorting)
Sort tables and ranges dynamically by single or multiple columns in ascending or descending order using the SORT and SORTBY formulas.
=SORT(array, [sort_index], [sort_order], [by_col]) SUMIFS Function in Excel & Google Sheets (Sum with Multiple Criteria)
Master SUMIFS in Excel and Google Sheets to add numbers based on multiple conditions, dates, text criteria, and wildcards.
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...]) SWITCH Function in Excel & Google Sheets (Match Expressions to Values)
Master the SWITCH function in Excel and Google Sheets to map codes, categories, and IDs without repetitive IF statements.
=SWITCH(expression, val1, result1, [val2, result2, ...], [default]) TEXTJOIN Function in Excel & Google Sheets (Join Text with Delimiters)
Combine text from ranges with custom delimiters and automatically ignore empty cells using TEXTJOIN in Excel and Google Sheets.
=TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...]) TEXTSPLIT Function in Excel & Google Sheets (Split Text by Delimiters)
Split delimited text into columns or rows using TEXTSPLIT in Excel (and SPLIT in Google Sheets) without the manual Text to Columns wizard.
=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with]) UNIQUE Function in Excel & Google Sheets (Extract Distinct Values)
Extract distinct values, remove duplicates dynamically, and find items that occur exactly once using the UNIQUE formula in Excel and Google Sheets.
=UNIQUE(array, [by_col], [exactly_once]) VLOOKUP Function in Excel & Google Sheets: Syntax, Examples & Pitfalls
Master VLOOKUP in Excel and Google Sheets. Learn exact match vs approximate match, column index numbering, fixing #N/A, and handling multiple sheets.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) XLOOKUP Function in Excel & Google Sheets: Syntax, Examples & Guide
Master XLOOKUP in Excel and Google Sheets. Replace VLOOKUP, HLOOKUP, and INDEX/MATCH with exact match, wildcard, two-way, and reverse lookups.
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])