Spreadsheet Formulas and Functions

sum

• =SUM(B2:B12)
• =A2*A3
• add all the numbers in a range of cells
• =SUM(B8:B20)*SUM(C28:C40)

average

• =AVERAGE(A2:Q2)
• =B8-N9
• =MIN(B1:G10)
• return the average of its arguments

max

• =MIN(B1:G10)
• =SUM(C1:W1)
• =SUM(B8:B20)*SUM(C28:C40)
• return the largest value in a set of values

min

• =MAX(B1:B31)
• =B2/SUM(B10:B21)
• return the largest value in a set of values
• return the smallest value in a set of values

count

• =SUM(C1:W1)
• =B8-N9
• =A6*SUM(C1:G10)/A2
• count the number of cells in a range that contains numbers

vlookup

• add all the numbers in a range of cells
• looks up a value from the leftmost column of a table,and returns a value in the same row from a column you specify
• =SUM(A1:C10)-B8
• =B8-N9

Formula: Add a range of numbers in cells B2:B12

• =SUM(C1:W1)
• =B8-N9
• return the smallest value in a set of values
• =SUM(B2:B12)

Formula: Find the largest number in cell C14 through Z14

• =B2/SUM(B10:B21)
• =AVERAGE(A2:Q2)
• =A2*A3
• =MAX(C14:Z14)

Write a formula (function) to add the range of cells C1:W1.

• return the largest value in a set of values
• =SUM(C1:W1)
• =MAX(B1:B31)
• =AVERAGE(A2:Q2)

Divide B2 by the sum of the range of cells in B10 through B21

• =SUM(C1:W1)
• =AVERAGE(A2:Q2)
• =A6*SUM(C1:G10)/A2
• =B2/SUM(B10:B21)