Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can create a formula to calculate values in your worksheet by using a function. For example, the formulas =SUM(A1:A2) and SUM(A1,A2) both use the SUM function to add the values in cells A1 and A2. Formulas always start with an equal sign (=).

  1. Click the cell where you want the formula.

  2. To start the formula with the function, click in the formula bar Button image or start typing the formula in the cell.

    Tip:  For a list of available functions, see functions (alphabetical) or functions (by category).

  3. After you complete the arguments for the formula, press Enter to see the formula result in the cell.

Tip:  If you frequently use functions, you can enter your formulas directly on the worksheet. After you type the equal sign (=) and the function name, you can see information about the formula syntax and the function arguments.

Examples

Use the data here to work with examples of formulas using a function. You can see and change formulas, and enter your own formulas.

Copy the table to cell A1 in a blank worksheet to work with these examples of formulas that use functions.

Data

5

4

2

6

3

8

7

1

Formula

Description

Result

'=SUM(A:A)

Adds all numbers in column A

=SUM(A:A)

'=AVERAGE(A1:B4)

Averages all numbers in the range A1:B4

=AVERAGE(A1:B4)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×