Count 
Count cells equal to 
COUNTIFSUMPRODUCTEXACT 
Count cells not equal to 
COUNTIF 
Count cells equal to either x or y 
COUNTIFSUMPRODUCTSUM 
Count cells equal to both x and y 
COUNTIFS 
Count cells greater than or less than 
COUNTIF 
Count number of cells between two values / dates 
COUNTIFS 
Count number of cells not between two given numbers 
COUNTIFSUMPRODUCT 
Count number of cells equals to one of many values 
COUNTIFSUMPRODUCT 
Count number of cells not equal to many values 
COUNTIFCOUNTASUMPRODUCT ISNAMATCH 
Count number of cells not equal to x or y 
COUNTIFSSUMPRODUCT 
Count blank or nonblank cells 
COUNTBLANKCOUNTIF 
Count cells that begin/end with specific text 
COUNTIF 
Count cells that contain either x or y 
SUMPRODUCTISNUMBERFIND 
Count cells that contain specific text with case sensitive 
SUMPRODUCTISNUMBERFIND 
Count How Many Cells Contain Errors 
SUMPRODUCTISNUMBERSUM 
Count number of cells contain numeric or nonnumeric values 
SUMPRODUCTISNUMBERNOTCOUNT 
Count number of cells that contain odd or even numbers 
SUMPRODUCTMOD 
Count number of cells that contain positive or negative values 
COUNTIF 
Count number of cells that contain specific number of characters 
COUNTIFSUMPRODUCTLENN 
Count Number Of Cells That Contain Specific Text 
COUNTIFSUMPRODUCTFINDISNUMBER 
Count the number of text cells 
COUNTIFCOUNTIFS 
Count cells that do not contain errors 
ISERRORSUMPRODUCTSUM 
Count cells that do not contain specific text 
COUNTIFCOUNTIFS 
Count Number Of Cells That Do Not Contain Many Values 
SUMMMULTISNUMBERTRANSPOSEROW 
Count Number Of Dates By Day Of Week 
SUMSUMPRODUCTWEEKDAY 
Count Multiple Criteria With NOT Logic 
SUMPRODUCTMATCH 
Count Numbers That Begin With A Specific Number 
SUMPRODUCTLEFT 
Count Occurrences Of Particular Text In Entire Excel Workbook 
SUMPRODUCTCOUNTIFINDIRECT 
Count Or Sum Only Whole Numbers 
SUMPRODUCT MOD 
Count Numbers Where The Nth Digit Equals To X 
SUMPRODUCT MID 
Count cells that match two or more criteria 
COUNTIFS 
Count matches between two columns 
SUMPRODUCT 
Count number of dates by year, month 
SUMPRODUCTYEARMONTH 
Count rows if meet internal criteria 
SUMPRODUCT 
Count Rows If Meet Multiple Criteria 
SUMPRODUCT 
Count All Matches / Duplicates Between Two Columns 
SUMPRODUCTCOUNTIFCOUNTMATCHISNUMBER 
Count Number Of Rows That Contain Specific Values 
SUMMMULTTRANSPOSECOLUMN 
Count Number Of Rows With Multiple OR Criteria 
SUMPRODUCT 
Count Unique Numeric Values Based On Criteria 
SUMFREQUENCYROWSUNIQUEFILTER 
Count Unique Numeric Values Or Dates In A Column 
SUMFREQUENCYISNUMBERUNIQUECOUNTIFCOUNT 
Count Number Of Visible Rows In A Filtered List 
SUBTOTAL 
Count Unique Values In A Range 
SUMPRODUCTFREQUENCYMATCHROWCOUNTIF 
Count Unique Values With Criteria 
SUMFREQUENCYMATCHROWIF 
Count Visible Rows With Criteria 
SUMPRODUCTSUBTOTALROWMIN 
Use COUNTIF On A NonContiguous Range 
SUMCOUNTIFINDIRECT 
Countifs With OR Logic For Multiple Criteria 
SUMCOUNTIFSUMPRODUCTMATCH ISNUMBER 
Calculate Percentage Breakdown Of Items In A List 
COUNTIFCOUNTA 
Create A Summary Count By Month With COUNTIFS 
COUNTIFSEDATE 
Do Running Count Of Occurrence In A List 
COUNTIFIF 
Summary Count Of NonBlank Categories 
COUNTIFS 
Sum 
3D sum or sumif across multiple worksheets 
SUMSUMPRODUCTSUMIFINDIRECT 
Calculate Running Total 
SUM 
Get Subtotal By Invoice Number 
COUNTIFSUMIFIF 
Sum Values By Group 
SUMIFIF 
Subtotal By Colors 
SUMIF 
TwoWay Summary Counting 
COUNTIF 
Subtotal Invoice Amounts By Age 
SUMIF 
Sum All Number Cells Ignoring Errors 
SUMIFIFERRORAGGREGATE 
Sum Smallest Or Bottom N Values 
SUMPRODUCTSMALL 
Sum Smallest Or Bottom N Values Based On Criteria 
SUMSMALLIF 
Sum Values By Month (With Or Without Year) 
SUMIFSSUMPRODUCTEOMONTHMONTH 
Sum Values By The Week Of A Given Date 
SUMIFS 
Sum Values By Weeknum Or Weekday 
WEEKNUMSUMPRODUCTWEEKDAY 
Sum Every N Rows Or Columns 
SUMOFFSETROWCOLUMNS 
Sum Every Nth Row Or Column 
SUMPRODUCTMODROWCOLUMN 
Sum If Begins With Or Ends With Specific Text Or Characters 
SUMIF 
Sum If Cells Contain Specific Text In Another Column 
SUMIFSUMPRODUCTSEARCHISNUMBER 
Sum If Between Two Values 
SUMIFS 
Sum Only Cells Containing Formulas 
SUMPRODUCTISFORMULA 
Sum Values By Year 
SUMPRODUCT SUMIFS DATE YEAR 
Sum If Cells Contain An Asterisk 
SUMIF 
Sum If Cells Contain Both X And Y 
SUMIFS 
Sum If Cells Contain Or Equal To Either X Or Y 
SUMPRODUCT ISNUMBER SEARCH SUMIFS 
Sum If Date Is Between Two Dates 
SUMIFS 
Sum If Cells Are Equal Or Not Equal To A Certain Value 
SUMIF 
Sum If Greater Than Or Less Than A Specific Value 
SUMIF 
Sum If Date Is Greater Than Or Less Than A Specific Date 
SUMIF 
Sum If Equal To One Of Many Things 
SUMIFSUMPRODUCT 
Sum Values Based On Blank Or NotBlank Criteria 
SUMIF 
Sumif With Multiple Criteria Based On OR And AND Logic 
SUMIFSUMIFS 
Sum Multiple Columns If One Criterion Is Met 
SUMPRODUCT 
Sum The Last N Columns 
SUM INDEX COLUMNS 
Sum Top N Values Or Top N Values With Criteria 
SUMPRODUCT LARGE 
Sum Values Based On Column Or Both Column And Row 
SUMPRODUCT 
Sum Values In Last N Days Based On Criteria 
SUMIFS TODAY 
Sum only visible cells or rows in a filtered list 
SUBTOTAL 
Sum values in horizontal range 
SUMIFS 
Use SUMIFS with multiple criteria based on OR logic 
SUMSUMIFS 
Use SUMPRODUCT with IF function 
SUMPRODUCT 
Financial 
Calculate interest payments per period or total 
IPMTCUMIPMT 
Lookup 
Approximate match with INDEX and MATCH 
INDEXMATCH 
Approximate match with VLOOKUP 
VLOOKUP 
Casesensitive lookup 
INDEXMATCHVLOOKUPEXACTCHOOSE 
Casesensitive lookup to return matching numbers 
SUMPRODUCTMATCHEXACT 
Count missing values 
SUMPRODUCTMATCHISNACOUNTIF 
Dynamic worksheet or workbook reference 
INDIRECT 
Exact match with INDEX and MATCH 
INDEXMATCH 
Exact match with VLOOKUP 
VLOOKUP 
Find longest or shortest text string in a column or row 
INDEXMATCHLENMAXMIN 
Find longest text string with criteria 
INDEXMATCHLENMAX 
Find missing values 
IFISNAMATCHVLOOKUPCOUNTIF 
Get cell address of lookup results 
INDEXMATCHCELL 
Get first nonblank value in a column or row 
INDEXMATCHISBLANK 
Get first numeric value in a column or row 
INDEXMATCHISNUMBER 
Get first text value in a column 
INDEXMATCHVLOOKUP 
Get first text value in a row 
HLOOKUP 
Get information corresponding to maximum value 
INDEXMATCHMAX 
Get information corresponding to minimum value 
INDEXMATCHMIN 
Get last text value in a column 
INDEXMATCH 
Get student or employee information with VLOOKUP 
VLOOKUP 
Get value at given row and column 
INDEXMATCHSMALL 
INDEX and MATCH across multiple columns 
INDEXMATCHMMULTTRANSPOSECOLUMN 
INDEX and MATCH with multiple arrays 
INDEXMATCHCHOOSE 
Left lookup with INDEX and MATCH 
INDEXMATCH 
Left lookup with VLOOKUP 
VLOOKUPCHOOSE 
Locate maximum value in a range 
MATCHMAX 
Locate first error 
MATCHISERROR 
Locate first match that does not begin with 
MATCHLEFTIF 
Locate first match that does not contain 
MATCHISNUMBERSEARCH 
Locate first partial match with wildcards 
MATCH 
Lookup a value containing specific text with wildcards 
INDEXMATCH 
Lookup closest match 
INDEXMATCHABSMIN 
Lookup closest match value with multiple criteria 
IFINDEXMATCH 
Lookup and retrieve entire column 
INDEXMATCHSUMAVERAGEMAXLARGE 
Lookup and retrieve entire row 
INDEXMATCHSUMAVERAGEMIN 
Lookup next largest match with INDEX and MATCH 
INDEXMATCH 
Lookup the first partial match number 
MATCHTEXTINDEX 
Lookup values in descending order 
INDEXMATCH 
Lookup values from another worksheet or workbook 
VLOOKUP 
Merge tables with INDEX and MATCH 
INDEXMATCH 
Multiplecriteria lookup with INDEX and MATCH 
INDEXMATCH 
Partial match with VLOOKUP 
VLOOKUP 
Retrieve first list value from a cell 
INDEXMATCHSEARCHISNUMBER 
Retrieve first matching value in cell against a list 
INDEXMATCHSEARCHAGGREGATE 
Retrieve information associated with lowest n values 
VLOOKUP 
Retrieve nth match with INDEX 
INDEXROWSMALLIF 
Retrieve nth match with VLOOKUP 
VLOOKUP 
Shipping cost calculator 
VLOOKUP 
Twoway approximate match with multiple criteria 
INDEXMATCHIF 
Twoway lookup with INDEX and MATCH 
INDEXMATCH 
Vlookup with dymanic sheet name 
VLOOKUPINDIRECT 
Math 
Convert binary value to decimal or octal or hex value 
BIN2DECDECIMALBIN2OCTBIN2HEX 
Convert hexadecimal value to decimal or binary or octal value 
HEX2DECDECIMALHEX2OCTHEX2BIN 
Convert octal value to decimal or binary or hexadecimal value 
OCT2DECDECIMALOCT2HEXOCT2BIN 
Convert decimal value to binary or octal or hexadecimal value 
DEC2DECDEC2OCTDEC2HEX 
Convert decimal number to IP address 
MID 
Convert decimal to whole number in Excel 
ROUND ROUNDDOWN ROUNDUP 
Date and Time 
Add business days to date 
WORKDAYWORKDAT.INTL 
Add hours to time 
TIME MOD 
Add minutes to time 
TIME MOD 
Add hours minutes seconds to time 
TIME 
Add months to date 

Add years to date 
DATEYEARMONTHDAY 
Assign points based on late time 
IFVALUE 
Add or subtract days to date 

Calculate days hours minutes seconds between two dates 
TEXT 
Calculate days remaining from today 
MAXTODAY 
Calculate days remaining between dates 

Calculate days remaining in month 
EOMONTH 
Calculate days remaining in year 

Calculate difference between two dates 
DATEDIF 
Calculate difference between two times 
IF 
Calculate expiry date 
EOMONTHEDATE 
Calculate hours minutes seconds between to times 
HOUR MINUTE SECOND 
Calculate network time 
MOD 
Calculate retirement date 
EDATE 
Calculate overlapping days 
MAXMIN 
Calculate overtime pay 

Calculate years months days between two dates 
DATEDIF 
Check if dates is workday 
WORKDAY WORKDAY.INTL 
Check if date is last n day 
TODAY AND 
Check if date is last n month from today 
TODAY AND EOMONTH 
Check if two dates are in same year month 
MONTH YEAR 
Combine date and time 
TEXT CONCATENATE 
Convert date to Julian 
TEXT YEAR DATE 
Convert date to month year day 
TEXT 
Convert date to text 
TEXT 
Convert datetime string to datetime 
LEFT MID 
Convert decimal hours to time 

Convert decimal minutes to time 

Convert month name to number 
DATEVALUE MONTH 
Convert number to date 
TEXT LEFT MID RIGHT DATE 
Convert time to another time zone 
MOD 
Convert time to decimal hours 

Convert time to decimal minutes 

Convert time to decimal seconds 

Convert time to money 

Convert time to Unix 
DATE 
Convert timestamp to time 
MID TIME 
Convert text to time 
DATEVALUE VALUE 
Count days of month 
EOMONTH DAY 
Count days until expiration date 
TODAY 
Count day of week between two dates 
INDIRECR ROW WEEKDAY SUMPRODUCT 
Count day of week in a date range 
WEEKDAY SUMPRODUCT 
Count days from Today 
TODAY IF ISBLANK ABS 
Count days between two dates 
DATEDIF 
Count dyas left in current month year 
EOMONTH YEAR DATE 
Count holidays between two dates 
SUMPRODUCT 
Count months between two dates 
DATEDIF YEARFRAC 
Count number of calls in a time range 
COUNTIFS 
Count times in a range 
COUNTIFS 
Count workday only 
NETWORKDAYS NETWORKDAYS.INTL 
Create date range from two dates 
TEXT 
Create dynamic date list 
ROWS 
Create weekly date range 
ROWS TEXT 
Custom format weekday name 
WEEKDAY CHOOSE 
Display current date or time 
TODAY NOW 
Extract time only from datetime in Excel 
TIMEMOD 
Extract date only from datetime in Excel 
INTTRUNC DATE 
Find earlest or latest date of each group 
IF MAX MIN 
Find last weekday of month 
EOMONTH WEEKDAY 
Find next date in schedule list 

Get day name from given date 
TEXT WEEKDAY CHOOSE 
Get date from day month year 
DATE 
Get first or last workday in month 
YEAR MONTH DATE WORKDAY 
Get fiscal month from date 
MONTH CHOOSE 
Get fiscal quarter from date 
MONTH CHOOSE 
Get fiscal year from date 
MONTH YEAR 
Get first or last day of month by given date 
DAY EOMONTH 
Get first day of month by month text name 
IF 
Get first or last day of previous month 
EOMONTH 
Get midpoint of two dates 
SUM WORKDAY 
Get Monday of week 
WEEKDAY 
Get month from date 
MONTH 
Get most recently day of week 
MOD 
Get next specific weekday 
WEEKDAY 
Get nth day of week in month by given date 
WEEKDAY DAY 
Get nth day of year by given date 
YEAR DATE 
Get number of workday between two dates 
NETWORKDAYS NETWORKDAYS.INTL 
Get percentage of year complete or remained 
YEAR DATE YEARFRAC 
Get quarter from date 
MONTH YEAR 
Get same date last month or next month 
EDATE 
Get same date last year or next year 
EDATE 
Get week number from date in Excel 
WEEKNUM 
Get work hours between two dates in Excel 
NETWORKDAYS NETWORKDAYS.INTL 
Get or calculate age from birth date in Excel 
YEARFRAC DATEDIF 
List holidays between two dates 
IF TEXTJOIN 
Text 
Abbreviate Words or Names 
TEXTJOIN ISNUMBER ROW INDIRECT LEN MATCH MID TRIM LEFT SUBSTITUTE FIND UPPER 
Add area code or country code to phone number 
CONCATENATE 
Add character before each word 
SUBSTITUTE 
Add comma after first word 
REPLACE FIND 
Add comma between names 
FINDREPLACE TRIM SUBSTITUTE 
Add dashes to phone number 
REPLACE 
Add dashes to SSN in a cell 
LEFT MID RIGHT SUBSTITUTE 
Add leading zeros to fix text length 
TEXT 
Add text in middle 
LEFT MID REPLACE 
Add space after comma 
TRIM SUBSTITUTE 
Add space between number and text 
TRIMREPLACE MIN FIND MAX IFERROR ROW INDIRECT LEN 
Capitalize first letter of text string or each word 
UPPERLEN FIND LOWER REPLACE LEFT MID 
Check if a cell contains a specific text 
ISNUMBER SEARCH FIND 
Check if cell contains all of many things 
SUMPRODUCT ISNUMBER SEARCH COUNTA 
Check if cell contains one of many things 
SUMPRODUCT ISNUMBER SEARCH 
Check if a cell contains one of several values but exclude other values 
SUMPRODUCT ISNUMBER SEARCH 
Check if cell contains some texts but not contains others 
COUNT SEARCH AND 
Convert letter to number 
COLUMN INDIRECT 
Check if cell contains number 
COUNT FIND 
Combine cells with line break 
CONCATENATE 
Combine date and time into one cell in Excel 
TEXT 
Combine text and date into same cell in Excel 
TEXT CONCATENATE 
Count comma separated values in a cell 
LEN SUBSTITUTE TRIM 
Count specific character in cell 
LEN SUBSTITUTE 
Count specific character in a range of cells 
SUMPRODUCT LEN SUBSTITUTE 
Count specific words in cell 
LEN SUBSTITUTE 
Count specific words in a range of cells 
SUMPRODUCT LEN SUBSTITUTE 
Count number of characters in a cell 
LEN 
Count number of characters in a range of cells 
SUMPRODUCT LEN 
Count number of words in a cell 
LEN TRIM SUBSTITUTE 
Count number of words in a range of cells 
SUMPRODUCT LEN TRIM SUBSTITUTE 
Use double quotes in formulas 
CHAR 
Check if cell equals any value in list 
SUMPRODUCT 
Clean and reformat telephone numbers 
SUBSTITUTE 
Combine cells with commas 
TRIM SUBSTITUTE CONCATENATE 
Combine initial and last name 
LEFT CONCATENATE 
Compare two or more text strings 
EXACT IF COUNTIF 
Concatenate cells but ignore blanks 
TEXTJOIN 
Convert numbers to text in Excel 
TEXT FIXED 
Convert text to number in Excel 
VALUE RIGHT LEFT MID 
Count keywords cell contains based on a list 
SUMPRODUCT ISNUMBER SEARCH 
Count lines which are separated by line breaks in a cell or a range 
LEN SUBSTITUTE 
Show specific text based on value in Excel 
REPT IF 
Extract all words but first or last from a cell 
RIGHT LEN FIND LEFT SUBSTITUTE 
Extract capital letters only 
SUBSTITUTE 
Extract extension from filename 
RIGHT LEN FIND SEARCH REPLACE 
Extract filename from a path in Excel 
MID FIND SUBSTITUTE LEN IFERROR 
Extract first line of cell 
SEARCH LEFT 
Extract first and last name from email 
FIND LEFT LEN RIGHT 
Extract folder name from path 
FIND SUBSTITUTE LEN RIGHT 
Extract from right until a character 
SEARCH RIGHT SUBSTITUTE LEN IFERROR 
Extract initials from names 
MID IF FIND LEFT 
Extract multiple lines from a cell 
TRIM MID REPT LEN SUBSTITUTE 
Extract last line of text from a multiline cell 
SUBSTITUTE REPT RIGHT TRIM 
Extract nth word from text string in Excel 
SUBSTITUTE REPT MID TRIM LEN 
Extract path from full path 
FIND SUBSTITUTE LEN LEFT 
Extract substring from text string in Excel 
MID LEFT RIGHT SEARCH 
Extract the last two words from a cell 
MID FIND SUBSTITUTE LEN 
Extract text between parentheses from text string 
MID SEARCH 
Extract word beginning with a specific character in Excel 
MID TRIM LEFT FIND REPT LEN SUBSTITUTE 
Extract word which containing specific text in Excel 
MID TRIM FIND REPT MAX SUBSTITUTE 
Extract first initial and last name from full name 
LEFT RIGHT FIND LEN 
Extract first middle and last names from full name in Excel 
LEFT RIGHT FIND LEN MID SEARCH SUBSTITUTE 
Extract text before or after second space or comma 
LEFT MID FIND SUBSTITUTE TRIM 
Extract text after the last instance of a specific character 
RIGHT SEARCH LEN SUBSTITUTE TRIM REPT 
Extract text between first and second comma from text strings 
MID SEARCH FIND SUBSTITUTE 
Find and replace multiple values in Excel 
SUBSTITUTE INDEX 
Find nth occurrence of character in a cell 
SUBSTITUTE FIND 
Find most frequenst text in a range 
MODE INDEX MATCH 
Find most frequenst text with criteria 
MODE INDEX IF MATCH 
Find position of nth occurrence 
FIND SUBSTITUTE 
Flip or reverse first and last names in Excel list 
MID SEARCH LEN 
Get or extract the first word from text string in Excel 
FIND LEFT 
Get or extract the last word from text string in Excel 
TRIM RIGHT REPT 
If cell contains text then display in Excel 
IF ISNUMBER SEARCH 
Make text same length 
REPT LEN 
Make first letter lowercase 
LEFT LOWER REPLACE 
Move or combine multiple cell contents into one cell 
CONCATENATE TRANSPOSE TEXTJOIN 
Normalize text 
TRIM SUBSTITUTE LOWER 
Remove extension from filename 
FIND LEFT 
Remove first n characters 
LEN RIGHT 
Remove first or last word from a string 
RIGHT LEN FIND LEFT TRIM SUBSTITUTE 
Remove from right of text 
LEN LEFT 
Excel remove last or trailing comma in a cell 
IF RIGHT LEFT LEN 
Remove leading and tailing space 
CLEAN TRIM SUBSTITUTE 
Remove line breaks from cells in Excel 
CLEAN TRIM SUBSTITUTE 
Remove middle initial from full name in Excel 
LEFT RIGHT FIND TRIM SUBSTITUTE REPT 
Remove prefix or suffix from string 
RIGHT LEN LEFT 
Remove text from cell by matching the content 
SUBSTITUTE 
Remove text from a cell based on specific position 
REPLACE SUBSTITUTE 
Remove text based on variable position in Excel 
REPLACE FIND 
Remove unwanted characters from cell in Excel 
SUBSTITUTE 
Remove text before or after first or last specific character from text strings 
RIGHT LEFT FIND SEARCH LEN SUBSTITUTE 
Remove text after or before the second or nth space from text strings 
RIGHT LEFT FINDLEN SUBSTITUTE 
Remove text within parentheses or brackets from text strings 
FIND MID LEN SUBSTITUTE 
Replace a specific character in a cell with another 
SUBSTITUTE 
Reverse the text string in a cell in Excel 
TEXTJOIN MID 
Split dimensions into individual length, height and width 
LEFT MID RIGHT FIND LEN SUBSTITUTE 
Split dimensions into two parts in Excel 
LEFT RIGHT FIND LEN SUBSTITUTE 
Separate numbers from units of measurement 
MAX ISNUMBER VALUE MID LEFT TRIM RIGHT 
Separate octets of IP address in Excel 
LEFT MID LEN FIND 
Separate Email addresses to usernames and domains 
LEFT RIGHT LEN FIND 
Split dollars and cents 
FIND RIGHT LEN 
Split a cell by first space in Excel 
LEFT FIND RIGHT LEN 
Split number into individual digits 
MID COLUMN 
Split sentence into words 
SEARCH MID ROW COLUMN IF 
Split text and numbers 
MID FIND LEFT RIGHT LEN 
Split text string at specific character in a cell in Excel 
MID FIND LEFT RIGHT LEN 
Split text with delimiter in a cell in Excel 
MID TRIM SUBSTITUTE LEN 
Strip or remove nonnumeric characters from text strings 
TEXTJOIN IFERROR MID ROW INDIRECT 
Strip or remove numeric characters from text strings 
TEXTJOIN IF ISERR MID ROW INDIRECT LEN 
Strip or remove html tags from text strings 
MID LEN 
Trim text to n words 
SUBSTITUTE FIND LEFT 