Excel Functions

K201

SUM

Adds a range of cells.

COUNT

Tallies the numbr of cells in a range that contain values (if it’s blank, it won’t include that cell)

COUNTA

Tallies the number of cells in a range that arent’t empty.

IF

Returns 1 value if the condition is true, and another if the condition is false.

MAX

Finds the largest value in a range.

MIN

Finds the smallest value in a range.

OR

Returns “True” if either condition is true.

RIGHT

Extracts a specified number of characters from the END of a text entry.

LEFT

Extracts a specified number of characters from the BEGINNING of a text entry

PROPER

Converts the first letter of each word to upprcase and all others to lowercase.

COUNTIF

Counts the number of cells in a range that meet a certain criteria.

VLOOKUP

Searches for the value you want in column A, and returns a matching value from COLUMN 2.

HLOOKUP

Searches for the value you want in column A, and returns a matching value from ROW 2.

AND

Returns “True” if both conditions are true.

XLOOKUP

Searches and returns a matching value from another column.

DATEDIF

Days between 2 dates.

MATCH

Returns the position of a value within a column.