Learn Excel
Menu
Count cells between dates
Count cells between two numbers
Count cells equal to
Count cells equal to case sensitive
Count cells equal to either x or y
Count cells equal to one of many things
Count cells greater than
Count cells less than
Count cells not equal to
Count cells not equal to many things
Count cells not equal to x or y
Count cells over 100 characters
Count cells that are blank
Count cells that are not blank
Count cells that begin with
Count cells that contain either x or y
Count cells that contain errors
Count cells that contain five characters
Count cells that contain negative numbers
Count cells that contain numbers
Count cells that contain odd numbers
Count cells that contain positive numbers
Count cells that contain specific text
Count cells that contain text
Count cells that do not contain
Count cells that do not contain errors
Count cells that end with
Count if row meets internal criteria
Count if row meets multiple internal criteria
Count if two criteria match
Count items in list
Count long numbers without COUNTIF
Count matches between two columns
Count multiple criteria with NOT logic
Count numbers that begin with
Count occurrences in entire workbook
Count paired items in listed combinations
Count rows that contain specific values
Count rows with at least n matching values
Count rows with multiple OR criteria
Count sold and remaining
Count total matches in two ranges
Count unique numeric values in a range
Count unique numeric values with criteria
Count unique text values in a range
Count unique text values with criteria
Count unique values in a range with COUNTIF
Count visible rows in a filtered list
Count visible rows only with criteria
Countif by weekday
COUNTIFS with multiple criteria and OR logic
Group numbers into ranges with COUNTIFS
Running count of occurrence in list
Summary count by month with COUNTIFS
Summary count of non-blank categories
Summary count with COUNTIF
Summary count with percentage breakdown
SUMPRODUCT count multiple OR criteria
Two-way summary count with COUNTIFS
3D sum multiple worksheets
3D SUMIF for multiple worksheets
Calculate running total
Subtotal by color
Subtotal by invoice number
Subtotal invoices by age
Sum 2d range with multiple criteria
Sum bottom n values
Sum bottom n values with criteria
Sum by group
Sum by month
Sum by month ignore year
Sum by week
Sum by week number
Sum by weekday
Sum columns based on adjacent criteria
Sum entire column
Sum every n rows
Sum every nth column
Sum if begins with
Sum if between
Sum if by year
Sum if cell contains text in another cell
Sum if cells are equal to
Sum if cells are not equal to
Sum if cells contain an asterisk
Sum if cells contain both x and y
Sum if cells contain either x or y
Sum if cells contain specific text
Sum if date is between
Sum if date is greater than
Sum if ends with
Sum if equal to either x or y
Sum if equal to one of many things
Sum if greater than
Sum if less than
Sum if multiple criteria
Sum if not blank
Sum if one criteria multiple columns
Sum last n columns
Sum sales in last 30 days by ID
Sum top n values
Sum top n values with criteria
Sum visible rows in a filtered list
SUMIFS with multiple criteria and OR logic
Average by month
Average last 5 values
Average last 5 values in columns
Average numbers
Average numbers ignore zero
Average response time per month
Average the last 3 numeric values
Average top 3 scores
Weighted average
First in, last out times
Large with criteria
Larger of two values
Max of every nth column
Maximum if multiple criteria
Maximum value
Maximum value if
Minimum if multiple criteria
Minimum value
Minimum value if
nth largest value
nth largest value with criteria
nth largest value with duplicates
nth smallest value
nth smallest value with criteria
Smaller of two values
Approximate match with multiple criteria
Basic INDEX MATCH approximate
Basic INDEX MATCH exact
Basic Tax Rate calculation with VLOOKUP
Break ties with helper column and COUNTIF
Calculate grades with VLOOKUP
Calculate shipping cost with VLOOKUP
Case sensitive match
Categorize text with keywords
Count missing values
Dynamic lookup table with INDIRECT
Exact match lookup with INDEX and MATCH
Exact match lookup with SUMPRODUCT
Extract data with helper column
Extract multiple matches into separate columns
Extract multiple matches into separate rows
Faster VLOOKUP with 2 VLOOKUPS
Find longest string in column
Find longest string with criteria
Find lowest n values
Find missing values
First match in range with wildcard
Get address of lookup result
Get employee information with VLOOKUP
Get first match cell contains
Get first non-blank value in a list
Get first text value in a list
Get first text value with HLOOKUP
Get information corresponding to max value
Get last match
Get last match cell contains
Get location of value in 2D array
Get nth match
Get nth match with INDEX / MATCH
Get nth match with VLOOKUP
Group arbitrary text values
Group numbers with VLOOKUP
If cell contains one of many things
INDEX and MATCH descending order
INDEX and MATCH with multiple criteria
Join tables with INDEX and MATCH
Lookup and sum column
Lookup entire column
Lookup entire row
Lookup last file version
Lookup latest price
Lookup lowest value
Lookup up cost for product or service
Lookup with variable sheet name
Map inputs to arbitrary values
Map text to numbers
Match first error
Match next highest value
Max if criteria match
Merge tables with VLOOKUP
Multi-criteria lookup and transpose
Multiple chained VLOOKUPs
Multiple matches in comma separated list
Next largest match with the MATCH function
Partial match against numbers with wildcard
Partial match with VLOOKUP
Position of first partial match
Position of max value in list
Self-contained VLOOKUP
Sum lookup values using SUMIF
Sum range with INDEX
Two-way lookup with INDEX and MATCH
Two-way lookup with VLOOKUP
VLOOKUP by date
VLOOKUP from another sheet
VLOOKUP from another workbook
VLOOKUP with 2 lookup tables
VLOOKUP with multiple critiera
VLOOKUP with numbers and text
VLOOKUP with two client rates
VLOOKUP without #N/A error
Force negative numbers to zero
If cell begins with x, y, or z
If cell contains
if cell contains this or that
If cell equals
If cell is blank
If cell is greater than
If cell is not blank
If cell is this OR that
If cell is x or y and z
If else
If NOT this or that
If this AND that
If this AND that OR that
Invoice status with nested if
Nested IF function example
Tax rate calculation with fixed base
Win loss points calculation
Highlight 3 smallest values with criteria
Conditional formatting dates overlap
Conditional formatting gantt chart
Conditional formatting gantt chart weekends
Conditional formatting highlight target percentage
Find duplicate values in two columns
Highlight approximate match lookup conditional formatting
Highlight blank cells
Highlight bottom values
Highlight cells that begin with
Highlight cells that contain
Highlight cells that contain one of many
Highlight cells that end with
Highlight cells that equal
Highlight column differences
Highlight data by quartile
Highlight dates between
Highlight dates greater than
Highlight dates in same month and year
Highlight dates in the next N days
Highlight dates that are weekends
Highlight duplicate columns
Highlight duplicate rows
Highlight duplicate values
Highlight entire rows
Highlight every other row
Highlight integers only
Highlight missing values
Highlight multiples of specific value
Highlight numbers that include symbols
Highlight row and column intersection exact match
Highlight rows that contain
Highlight rows with blank cells
Highlight rows with dates between
Highlight top values
Highlight unique values
Highlight unprotected cells
Highlight values between
Highlight values greater than
Highlight values not between X and Y
Shade alternating groups of n rows
Data validation allow numbers only
Data validation allow text only
Data validation allow uppercase only
Data validation allow weekday only
Data validation contains specific text
Data validation date in next 30 days
Data validation date in specific year
Data validation don't exceed total
Data validation exists in list
Data validation must begin with
Data validation must not contain
Data validation must not exist in list
Data validation only dates between
Data validation require unique number
Data validation unique values only
Data validation whole percentage only
Data validation with conditional list
Rank function example
Rank race results
Get decimal part of a number
Get integer part of a number
Get number at place value
Round a number
Round a number down
Round a number down to nearest multiple
Round a number to n significant digits
Round a number to nearest multiple
Round a number up
Round a number up to nearest multiple
Round a number up to next half
Round a price to end in .99
Round by bundle size
Round time to nearest 15 minutes
Round to nearest 1000
Round to nearest 5
Add business days to date
Add days exclude certain days of week
Add days to date
Add decimal hours to time
Add decimal minutes to time
Add months to date
Add workdays no weekends
Add workdays to date custom weekends
Add years to date
Assign points based on late time
Basic overtime calculation formula
Calculate date overlap in days
Calculate days remaining
Calculate expiration date
Calculate number of hours between two times
Calculate retirement date
Calculate years between dates
Convert date string to date time
Convert date to Julian format
Convert date to month and year
Convert date to text
Convert decimal hours to Excel time
Convert decimal minutes to Excel time
Convert decimal seconds to Excel time
Convert text date dd/mm/yy to mm/dd/yy
Convert text to date
Convert time to time zone
Count birthdays by month
Count day of week between dates
Count holidays between two dates
Count times in a specific range
Create date range from two dates
Custom weekday abbreviation
Date is same month
Date is same month and year
Date is workday
Days in month
Days until expiration date
Display the current date
Display the current date and time
Extract date from a date and time
Extract time from a date and time
Get age from birthday
Get date from day number
Get day from date
Get day name from date
Get days before a date
Get days between dates
Get days between dates ignoring years
Get days, hours, and minutes between dates
Get days, months, and years between dates
Get first day of month
Get first day of previous month
Get first Monday before any date
Get fiscal quarter from date
Get fiscal year from date
Get last day of month
Get last weekday in month
Get last working day in month
Get month from date
Get month name from date
Get months between dates
Get most recent day of week
Get next day of week
Get nth day of week in month
Get nth day of year
Get percent of year complete
Get quarter from date
Get same date next month
Get same date next year
Get start date based on target date
Get week number from date
Get work hours between dates
Get work hours between dates custom schedule
Get workdays between dates
Get year from date
Group times into 3 hour buckets
Group times into unequal buckets
If Monday, roll back to Friday
Join date and text
Last updated date stamp
List holidays between two dates
Next anniversary date
Next biweekly payday from date
Next business day 6 months in future
Next working day
Pad week numbers with zeros
Random times at specific intervals
Sum race time splits
Time difference in hours as decimal value
Total hours that fall between two times
Workdays per month
Working days left in month
Year is a leap year
Series of dates by day
Series of dates by month
Series of dates by weekends
Series of dates by workdays
Series of dates by year
Abbreviate names or words
Add a line break with a formula
Add line break based on OS
Cell contains all of many things
Cell contains number
Cell contains one of many things
Cell contains one of many with exclusions
Cell contains some words but not others
Cell contains specific text
Cell contains which things
Cell equals one of many things
Clean and reformat telephone numbers
Compare two strings
Convert numbers to text
Convert string to array
Convert text to numbers
Count line breaks in cell
Count specific characters in a cell
Count specific characters in a range
Count specific words in a cell
Count specific words in a range
Count total characters in a cell
Count total characters in a range
Count total words in a cell
Count total words in a range
Double quotes inside a formula
Extract last two words from cell
Extract multiple lines from a cell
Extract nth word from text string
Extract text between parentheses
Extract word containing specific text
Extract word that begins with specific character
Find nth occurrence of character
Get first word
Get last line in cell
Get last word
Join cells with comma
Most frequently occurring text
Normalize text
Position of 2nd 3rd etc instance of character
Remove characters from left
Remove characters from right
Remove file extension from filename
Remove leading and trailing spaces from text
Remove text by matching
Remove text by position
Remove text by variable position
Remove unwanted characters
Replace one character with another
Split dimensions into three parts
Split dimensions into two parts
Split numbers from units of measure
Split text and numbers
Split text string at specific character
Split text with delimiter
Strip html from text or numbers
Strip non-numeric characters
Strip numeric characters from cell
Annual compound interest schedule
Calculate compound interest
Calculate cumulative loan interest
Calculate cumulative loan principal payments
Calculate interest for given period
Calculate interest rate for loan
Calculate original loan amount
Calculate payment for a loan
Calculate payment periods for loan
Calculate principal for given period
Calculate simple interest
Dynamic workbook reference
Dynamic worksheet reference
Get full workbook name and path
Get sheet name only
Get workbook name and path without sheet
Get workbook name only
Get workbook path only
Indirect named range different sheet
List sheet index numbers
Worksheet name exists
Create email address from name
Create email address with name and domain
Get domain from email address
Get domain name from URL
Get name from email address
Get top level domain (TLD)
Strip protocol and trailing slash from URL
Get first name from name
Get first name from name with comma
Get last name from name
Get last name from name with comma
Get middle name from full name
Join first and last name
Put names into proper case
Calculate percent variance
Decrease by percentage
Get amount with percentage
Get original number from percent change
Get original price from percentage discount
Get percent change
Get percentage discount
Get percentage of total
Get profit margin percentage
Get total from percentage
Increase by percentage
Percent of goal
Percent of students absent
Percent sold
Project complete percentage
Address of first cell in range
Address of last cell in range
All cells in range are blank
Dynamic named range with INDEX
Dynamic named range with OFFSET
First column number in range
First match between two ranges
First row number in range
Get address of named range
Get relative column numbers in range
Get relative row numbers in range
Last column number in range
Last row in mixed data with blanks
Last row in mixed data with no blanks
Last row in numeric data
Last row in text data
Last row number in range
Multiple cells are equal
Multiple cells have same value
Multiple cells have same value case sensitive
Range contains a value not in another range
Range contains numbers
Total cells in a range
Total columns in range
Total rows in range
Abbreviate state names
Basic attendance tracking formula
Basic error trapping example
Basic in cell histogram
Build hyperlink with VLOOKUP
Calculate a ratio from two numbers
Cap percentage at specific amount
Cash denomination calculator
Change negative numbers to positive
Check register balance
Convert column letter to number
Convert column number to letter
Copy value from every nth column
Copy value from every nth row
Count consecutive monthly orders
Count with repeating values
Course completion status summary
Course completion summary with criteria
Create array of numbers
Cube root of number
Easy bundle pricing with SUMPRODUCT
Extract unique items from a list
Filter values in array formula
Fixed value every N months
Flag first duplicate in a list
Flip table rows to columns
Formula with locked reference
Get date associated with last entry
Get first entry by month and year
Get last entry by month and year
Get pivot table grand total
Get pivot table subtotal
Get pivot table subtotal grouped date
Get value of last non-empty cell
Hyperlink to first blank cell
Hyperlink to first match
Increment a calculation with ROW or COLUMN
Increment a number in a text string
Issue response time calculation
Leave a comment in a formula
List contains duplicates
List most frequently occuring numbers
Longest winning streak
Lookup last file revision
Most frequently occurring number
Multiplication table formula
Normalize size units to Gigabytes
nth root of number
Pad a number with zeros
Random date between two dates
Random number between two numbers
Random number from fixed set of options
Random text values
Random value from list or table
Randomly assign data to groups
Randomly assign people to groups
Range contains one of many substrings
Range contains one of many values
Range contains specific text
Rank with ordinal suffix
Reverse a list or range
Search entire worksheet for value
Search multiple worksheets for value
Simple currency conversion
Split payment across months
Square root of number
Student class enrollment with table
Sum every 3 cells
Transpose table without zeros
Validate input with check mark
Value exists in a range
Value is between two numbers
Value is within tolerance
Volunteer hours requirement calculation
Excel DAVERAGE Function
Excel DCOUNT Function
Excel DCOUNTA Function
Excel DGET Function
Excel DMAX Function
Excel DMIN Function
Excel DPRODUCT Function
Excel DSTDEV Function
Excel DSTDEVP Function
Excel DSUM Function
Excel DVAR Function
Excel DVARP Function
Excel DATE Function
Excel DATEDIF Function
Excel DATEVALUE Function
Excel DAY Function
Excel DAYS Function
Excel DAYS360 Function
Excel EDATE Function
Excel EOMONTH Function
Excel HOUR Function
Excel ISOWEEKNUM Function
Excel MINUTE Function
Excel MONTH Function
Excel NETWORKDAYS Function
Excel NETWORKDAYS.INTL Function
Excel NOW Function
Excel SECOND Function
Excel TIME Function
Excel TIMEVALUE Function
Excel TODAY Function
Excel WEEKDAY Function
Excel WEEKNUM Function
Excel WORKDAY Function
Excel WORKDAY.INTL Function
Excel YEAR Function
Excel YEARFRAC Function
Excel BIN2DEC Function
Excel BIN2HEX Function
Excel BIN2OCT Function
Excel BITAND Function
Excel BITLSHIFT Function
Excel BITOR Function
Excel BITRSHIFT Function
Excel BITXOR Function
Excel CONVERT Function
Excel DEC2BIN Function
Excel DEC2HEX Function
Excel DEC2OCT Function
Excel HEX2BIN Function
Excel HEX2DEC Function
Excel HEX2OCT Function
Excel CUMIPMT Function
Excel CUMPRINC Function
Excel FV Function
Excel IPMT Function
Excel IRR Function
Excel MIRR Function
Excel NPER Function
Excel NPV Function
Excel PMT Function
Excel PPMT Function
Excel PV Function
Excel RATE Function
Excel XIRR Function
Excel XNPV Function
Excel CELL Function
Excel ERROR.TYPE Function
Excel INFO Function
Excel ISBLANK Function
Excel ISERR Function
Excel ISERROR Function
Excel ISEVEN Function
Excel ISFORMULA Function
Excel ISLOGICAL Function
Excel ISNA Function
Excel ISNONTEXT Function
Excel ISNUMBER Function
Excel ISODD Function
Excel ISREF Function
Excel ISTEXT Function
Excel N Function
Excel NA Function
Excel SHEET Function
Excel SHEETS Function
Excel TYPE Function
Excel AND Function
Excel FALSE Function
Excel IF Function
Excel IFERROR Function
Excel IFNA Function
Excel IFS Function
Excel NOT Function
Excel OR Function
Excel SWITCH Function
Excel TRUE Function
Excel XOR Function
Excel ADDRESS Function
Excel AREAS Function
Excel CHOOSE Function
Excel COLUMN Function
Excel COLUMNS Function
Excel FORMULATEXT Function
Excel HLOOKUP Function
Excel HYPERLINK Function
Excel INDEX Function
Excel INDIRECT Function
Excel LOOKUP Function
Excel MATCH Function
Excel MMULT Function
Excel OFFSET Function
Excel ROW Function
Excel ROWS Function
Excel TRANSPOSE Function
Excel VLOOKUP Function
Excel ABS Function
Excel ARABIC Function
Excel ASIN Function
Excel CEILING Function
Excel CEILING.MATH Function
Excel CEILING.PRECISE Function
Excel COS Function
Excel DECIMAL Function
Excel DEGREES Function
Excel EVEN Function
Excel EXP Function
Excel FACT Function
Excel FLOOR Function
Excel FLOOR.MATH Function
Excel FLOOR.PRECISE Function
Excel GCD Function
Excel INT Function
Excel LCM Function
Excel LN Function
Excel LOG Function
Excel LOG10 Function
Excel MOD Function
Excel MROUND Function
Excel ODD Function
Excel PI Function
Excel POWER Function
Excel QUOTIENT Function
Excel RADIANS Function
Excel RAND Function
Excel RANDBETWEEN Function
Excel ROMAN Function
Excel ROUND Function
Excel ROUNDDOWN Function
Excel ROUNDUP Function
Excel SIGN Function
Excel SIN Function
Excel SQRT Function
Excel SUBTOTAL Function
Excel SUM Function
Excel SUMIF Function
Excel SUMIFS Function
Excel SUMPRODUCT Function
Excel TAN Function
Excel TRUNC Function
Excel AVEDEV Function
Excel AVERAGE Function
Excel AVERAGEA Function
Excel AVERAGEIF Function
Excel AVERAGEIFS Function
Excel COMBIN Function
Excel COUNT Function
Excel COUNTA Function
Excel COUNTBLANK Function
Excel COUNTIF Function
Excel COUNTIFS Function
Excel DEVSQ Function
Excel FREQUENCY Function
Excel GEOMEAN Function
Excel HARMEAN Function
Excel LARGE Function
Excel MAX Function
Excel MAXA Function
Excel MAXIFS Function
Excel MEDIAN Function
Excel MIN Function
Excel MINA Function
Excel MINIFS Function
Excel MODE Function
Excel MODE.MULT Function
Excel MODE.SNGL Function
Excel PERCENTILE Function
Excel PERCENTILE.EXC Function
Excel PERCENTILE.INC Function
Excel PERCENTRANK Function
Excel PERCENTRANK.EXC Function
Excel PERCENTRANK.INC Function
Excel PERMUT Function
Excel QUARTILE Function
Excel QUARTILE.EXC Function
Excel QUARTILE.INC Function
Excel RANK Function
Excel RANK.AVG Function
Excel RANK.EQ Function
Excel SMALL Function
Excel STANDARDIZE Function
Excel STDEV Function
Excel STDEV.P Function
Excel STDEV.S Function
Excel STDEVA Function
Excel STDEVP Function
Excel STDEVPA Function
Excel TRIMMEAN Function
Excel VAR Function
Excel VAR.P Function
Excel VAR.S Function
Excel VARA Function
Excel VARP Function
Excel VARPA Function
Excel CHAR Function
Excel CLEAN Function
Excel CODE Function
Excel CONCAT Function
Excel CONCATENATE Function
Excel DOLLAR Function
Excel EXACT Function
Excel FIND Function
Excel LEFT Function
Excel LEN Function
Excel LOWER Function
Excel MID Function
Excel PROPER Function
Excel REPLACE Function
Excel REPT Function
Excel RIGHT Function
Excel SEARCH Function
Excel SUBSTITUTE Function
Excel TEXT Function
Excel TEXTJOIN Function
Excel TRIM Function
Excel UPPER Function
Excel VALUE Function
Excel GETPIVOTDATA Function
Close menu
Excel Shortcut
Tutorials
Functions