Excel Functions

COUNT

Counts cells that contain numbers

COUNTA

Counts cells that are not empty (numbers or text).

COUNTBLANK

Counts cells that are empty.

COUNTIF

Counts cells that meet one condition.

COUNTIFS

Counts cells that meet multiple conditions at the same time

SUM

Adds up numbers

SUM (n1, n2, …)

Adds up specific numbers or cells you list.

SUMIF

Adds numbers that meet one condition

SUMIFS

Adds numbers that meet one condition

AVERAGE

Finds the average of specific numbers or cells you list.

AVERAGEA

Finds the average and treats text/logical values as 0

AVERAGEA (n1, n2, …)

Finds the average of specific numbers or cells you list

AVERAGEIF

Finds the average of numbers that meet one condition

AVERAGEIFS

Finds the average of numbers that meet multiple conditions.

IF

Checks a condition and does one thing if true, another if false.

AND

 Returns TRUE only if all conditions are true.

OR

Returns TRUE if at least one condition is true

VLOOKUP

Looks up a value in the first column of a table and returns a value from the same row in another column.

TODAY()

Returns today’s date

TODAY() + 7

Returns the date 7 days from today.

DATEVALUE("1/1/2030") − TODAY()

Returns the number of days until Jan 1, 2030.

DATE(2018,9,20)

Creates a date (Sept 20, 2018).

DAY(TODAY())

Returns the day of the month

MONTH(TODAY())

 Returns the month number

YEAR(TODAY())

Returns the year

WEEKDAY(TODAY())

Returns the day of the week as a number.

WEEKDAY(date, return_type)

Returns the day of the week using a chosen numbering system.

DATEDIF(start, end, "Y")

Returns the number of full years between two dates

DATEDIF(start, end, "D")

Returns the number of days between two dates

WORKDAY

Returns a date that is a certain number of workdays before or after a start date (skips weekends and holidays)

WORKDAY.INTL

 Gives you a future or past date after counting a certain number of working days, where you decide which days are weekends and which dates are holidays.

NETWORKDAYS

Tells you how many working days are between two dates, not counting weekends or holidays.

LEN

Tells you how many characters are in text (letters, numbers, spaces, symbols)

SEARCH

Tells you where a word or letter appears inside text by giving its position number

LEFT

Takes a certain number of characters from the beginning of text

MID

Takes a certain number of characters from inside the text, starting at a position you choose

RIGHT

Takes a certain number of characters from the end of text

UPPER

Changes all letters in text to capital letters

LOWER

Changes all letters in text to lowercase letters.

PROPER

Capitalizes the first letter of each word.

CONCAT

Combines multiple pieces of text into one single piece of text.

SUBSTITUTE

 Replaces specific text with different text

MATCH

Finds where a value appears in a list and tells you its position number.

INDEX

Looks inside a table and returns the value from a specific row and column

CHOOSE

Selects one value from a list based on a number you provide