How to Sum in Excel

O excel It is a digital tool that has a variety of resources that help in different ways.

To the worksheets are used for jobs with finance, percentages and data tables. Therefore, knowing the operations is an essential quality to optimize the work.

A sum It is a basic operation and very used. the operation of sum in excel is represented by =Sum (cells that will be added). Also, the values ​​are separated by semicolon (;).

To know how to do sum in excel, check out this article!

Adding horizontal cells

1. Select a cell to contain the sum, type = sum and press Enter.

2. Select the cells to be added and press enter again.

Summing vertical cells

1. Select the cell where the sum will be made, insert the operation = sum and press enter.

2. Select the cells to be added and press Enter.

Adding a fixed value to the result

1. To add up a fixed amount, such as a one-time spend, enter the amount after a semicolon ; and press enter.

Summing specific columns

1. To sum two specific columns, enter = sum and press enter.

2. Select the first column to be summed, enter a semicolon and select the second column. Then press Enter.

Read too:

• How to Make a Table of Contents in Word
• Algorithm – What is it? What does it have to do with computing?
• What does upload mean in computing?