[go: up one dir, main page]
Scribd
Upload
40 views1 page

Formulas

Uploaded by

flowrieanne
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
40 views1 page

Formulas

Uploaded by

flowrieanne
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Formulas

 SUM function
o adds values.
o You can add individual values, cell references or ranges or a mix of all three
o Example: = Sum(a1:a6) Adds the values in cells A2:10
o =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.

 Average function
o a premade function in Excel, which calculates the average (arithmetic mean). It is typed
=AVERAGE. It adds the range and divides it by the number of observations. Example: The
average of (2, 3, 4) is 3.
 Max Function
o a premade function in Excel, which finds the highest number in a range.
o It is typed =MAX. The function ignores cells with text. It will only work for cells with
numbers.
 Min Function
o a premade function in Excel, which finds the lowest number in a range.
o It is typed =MIN. The function ignores cells with text. It will only work for cells with
numbers
 COUNT Function
o an Excel function that counts the number of cells within a specified range that contain
numeric values.

You might also like