This program Microsoft Office has become the right hand of most people and especially for big companies they need to do great number of calculations. And it is that this software stands out mainly for offering many tools that will allow you to perform mathematical operations very easily.
When working with numerical data in the software on many occasions they have to do some sums, this is a very simple process to do which will allow you automating your accounts and above all will offer you greater speed when working on the spreadsheet.
However, not all users know how to add in excel, so it turns out very important to explain said process. That is why here we are going to teach you step by step how you can do sums in the program and what are the formulas you can use for it.
Index:
What are the main Excel formulas for adding data into spreadsheets?
One of the main advantages that can be obtained when working with this Microsoft programis that it offers a wide variety of functions and formulas that will allow different types of operations math and calculations in a very simple way.
In the case of sums can be applied for many methods, that is why here we are going to teach you what are the main formulas you can find there so you can use in each of your worksheets.
Let’s see below:
SUM function
This formula is used for those cases where you want add two or more cells on your worksheet. To be able to apply it you must write it in the following way: = SUM (numbers and cell letters to be added separated by a comma) this would be as follows: = SUM (B4, B5, B6, B7)
In this way, all the values of the cells that have been introduced in the equation.
Use the + sign
Another way in which you can add values contained in spreadsheets is through plus sign, for this you must click on the cell where do you want will show you the result, the next will be to go to the option of “Insert function”.
There you must write the sign = and select each of the boxes that you want to add once you have selected the first you must press the key with the + sign so that it separates each of the values.
When all the corresponding values have been entered, simply press the “Enter” key in this way you can see how the result of the sum of all the values is reflected that you have previously selected.
SUM.YES function
Another function that can be used to add values is ADD IF, it allows add values of an interval than meet previously specified criteria.
An example of this would be that, in one of the columns of the spreadsheet has only numbers and you need only the values that are greater than 10, for this you would have to apply the following formula: = ADD.SI (A2: A10, “> 10”)
ADD.SY.CONJUNTO
This is another of the mathematical functions that you can add in each of your criteria at the time of work with excel. In this case you can use this function to add the number of retailers in the country that have a single postal code, and the profits that exceed a certain amount in euros.
The formula in this case would be the following: ADD.SY.CASE (range_sum, range_criteria1; criteria1; (range_criteria2; criteria2);….)
SUMA.SERIES
This is another formula available to carry out operations sum in Excel.
In this case it is the sum of power that has the following formula:
- SUMA.SERIES (x, n, m, coefficient)
Each of these values has the following argument:
- X: Mandatory, is the variable that is used as base on the exponential series.
- N: Mandatory, is the initial exponent to which base x rises.
- M: Mandatory, is the step in which increase the value of n for each term in the series.
- Coefficient: Mandatory, this will be the coefficient whereby each of the successive exponents of X. the number of values in the argument would be exponential.
Steps to make sums of any data in your spreadsheets in Microsoft Excel
Fortunately, Excel offers the possibility of add virtually any data found in your spreadsheet. That is why here We are going to teach you several methods that you can perform to add data in the program, in this case it’s about add figures, dates, hours, among other data that you can also add.
To do this, follow each of these methods that we will teach you below:
Figures
One of the ways faster and easier to add numbers in the calculation software is through the tool “Autosuma”, for this you must select a cell empty below the column of data.
The next thing is to go to the tab of “Formulas” and there you select the option of Autosuma and then “Sum”.
In this way Excel will automatically detect the interval to add. It also can work horizontally, for this you must select a empty cell to the right of the row.
Dates
The dates are other elements that can be add in excel, in this case this The procedure is performed with the sum of the values of a certain date or the sum of the values within a previously selected date range.
In this case it is necessary to use SUM function YES, which allows set the sum under a specific condition.
An example of all this would be the following:
- Having the data what we are going to teach you next the sum of all sales made before 04/01/2015 will be taken out and also will add all sales made on 01/05/2015.
- In order to determine the sum of pre-day sales 01/04/2015, it is necessary to use this function: = SUMSI (A2: A12; “<” & DATE82015; 1; 4); B2: B12).
- Now in order to get the sum of all sales made on the day 01/05/2015 it will be necessary to write the following function: = SUM ADD (A2: A12; “=” & DATE (2015; 1; 5); B2: B12).
Add days to a date
You can too handle excel dates as a number and use the addition and subtraction operations.
In the case of adding, you will need to follow these steps:
- Write the date in cell A2, either 05/19/2019.
- The next thing will be to click on it with the right mouse button and select the option “Cell format”.
- Now select within the tab the number of a short date format. You can too to select said option in drop-down menu of number options group, there you choose “Short date”.
- Now select cell B1 and write the following operation = A2 + 2, as you can see automatically it add the days to the date what do you have in the column A.
Hours
Power add hours in Microsoft Excel It is not such a simple task, since it will require apply some tricks that will allow you to do it the form correct. In this case it is recommended first add the minutes and then convert it to hours.
Although it should be mentioned that the biggest problem here occurs when the sum must be done with several cells that contain hours and minutes. Note that every 60 minutes will be an hour, this ends up complicating what will be the sum of these values.
Therefore, in the event that you have a cell range with hours and minutes in which a person has worked for a week in the company as you can see in the image.
So for the boss can pay the fees you will need to be clear the correct sum of the time you have worked. Here we will explain the easiest method to add hours and minutes.
In the cell B7 you must use the SUM function, this will allow add up all the values. Here you can see how the cell displays a time that does not correspond to the correct sum.
For this value of correctly you need to right click on cell B7, there choose the option of “Cell Format” and select the section “Number” and then the option of “Personalized” so you can finally choose the format (H): mm; ss.
In the case that for some reason don’t get the format, what you should do is capture it in the text box. As you can see, this format places the symbol for the hours in square brackets, allowing to show the correct result of the sum, when finished click on “To accept” so that the result is generated.
In this way you can start to carry out theas sums of hours and minutes in Excel without the need to carry out very complex procedures. As you can see, just enough modify the format of the cell that will display the final sum of the hours and minutes.
In case you want add minutes and hours you can apply the same trick but selected the correct format for it.