How to calculate the amount in exile

MS Exel - a powerful program for performing almost all mathematical and graphic tasks. Its possibilities are almost limitless. But most often it is used to perform typical uncomplicated calculations. One such calculation is to find the amount of the number of numbers. In this article, we will figure it out as in Excele to count the amount and what are the options for calculating the amount. Also briefly features the autosumma button.

1

The first way of calculating the amount in Excele

With this method, it is possible to calculate the amount of numbers that are in different cells. For this you need:

• Run the program or open a ready-made file.
• Make the necessary data in the appropriate cells.
• In the formula line, write equally and below, click on the necessary cells, select the data you need to summarize.

An example of such a formula: \u003d A1 + B2 + C9 + B11 (in the figure it is highlighted in different colors).

2

The second way of calculating the amount in Excel

This version of the calculation allows you to count the amount of the values \u200b\u200bthat are in the table. For this you need:

• Open an existing file or create a new one.
• Select the data table already existing or make new values.
• Click on the sigma sign (autosumma) on the top panel. By clicking on the arrow next to the sign of the Avosumn, you can choose which action you need to: summarize, average, the number, maximum minimum.

An example of formula: \u003d sums (A1: A6) (in the figure is highlighted with purple color).

3

Options Buttons Autosums in Excele

What does each function of the autosumma button mean?

• Summage - returns the amount of the selected values.
• The average value - the function returns the average value of the selected numbers.
• Number - Returns the number of numbers in the array.
• Maximum and minimum returns the maximum and minimum value of the array of numbers, respectively.
• If necessary, you can find other operations on numbers by clicking in the autosumma button drop-down menu to the "Other Functions" item.

We hope that this article has become useful in mastering the MS Exel program.