Excel Formulas - Francis Bacon

All formulas must begin with

• parenthesis

• sign

• equal sign

• uppercase

Data without this sign is considered a ____

SUM

• Calculates the average of a range of numbers.

• Counts the number of cells in a range that contain numbers.

• Adds up all the numbers in a range.

• Finds the largest value in a range of numbers.

Calculate the sum total of all cells in a range which meet the logical test.

Calculates the average of a range of numbers.

• =AVERAGEIF

• =AVERAGE

• =COUNT

• IF

Counts the number of cells in a range that contain numbers.

Join two or more strings together to create one text string

Count the number of cells in a range that contain a non-blank value and meet the logical test

• COUNT

• COUNTBLANCK

• COUNTA

• COUNTIF

It counts the number of non-blank cells in a cell range.

Counts the number of empty (do not contain any value) cells in the specified range.

• COUNT

• COUNTA

• COUNTBLANK

• COUNTIF