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 non-numeric 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 Non-Contiguous 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 Non-Blank 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 |
Two-Way 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 Not-Blank 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 |
Case-sensitive lookup |
INDEXMATCHVLOOKUPEXACTCHOOSE |
Case-sensitive 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 non-blank 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 |
Multiple-criteria 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 |
Two-way approximate match with multiple criteria |
INDEXMATCHIF |
Two-way 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 multi-line 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 non-numeric 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 |