How to add negative values ​​in Excel

Technology tools make it easy to solve complex math problems on a spreadsheet, which enables the user to increase their power of organization and data analysis in their ability to perform calculations. As an example a sum of negative values ​​in Excel.

Excel makes it possible to better understand mathematical operations, saving time in the elaboration of more difficult calculations when interacting with different databases to create an automated procedure.

Benefits of using spreadsheets to do your work

When it comes to Statistical data, calculations and reports with graphs and formulas Excel is undoubtedly one of the best alternatives since it allows:

• Have full control over data management so that you can sort and use it as you wish by adding plugins that allow you to facilitate data analysis.
• At the same time, get a summary of large amounts of data within a database for decision making.

• Save time working in a team of different users, while importing data from supported sites.
• You can create financial models or budgets from bank details.
• You can integrate several spreadsheets so you can simplify operations with all kinds of functions and formulas.

How to use the Sum function in Sheets

As we have already mentioned before, thanks to technological advances, accounting software such as Excel enables you to perform long math operations that facilitate human work.

As an example, the sum function enables you to calculate data from a very large table of contents immediately, carrying everything that is modified in the database to modify the result accordingly.

The sum function can be used with a formula called “Sum” what are you going to train using = SUM (A5: A15) O SUM (A5: A15, C8: C30 (number of cells)). Opposite case, you can insert a function directly from its tab in Excel, choose the sum function and insert it.

With the Add function if, You can add important groups of cells within a sheet if what is written there complies with a certain value or characteristic that you assign to it., in order to put aside everything you don't need to add; and you can insert it from the same formula tab looking for the option 'Add yes'.

Another way to get the most out of sums in Excel is by selecting the two columns you want to add and then typing ‘Alt + Shift + = ‘, this is the most manual way to do it. Despite this, with function Autosum Inside the formulas tab you will get automatic results when placed in front of a column.

How to make Excel consider negative values

Identify the negative numbers It's easy when they have a minus sign, but when it comes to large amounts of numbers in which you have to identify which ones are negative, as in a bank statement, it is usually much more complex to get them with the naked eye. .

Then, Excel enables you to have a better visualization of them through formats with which you feel comfortable, for this you only have to:

1. Select one or more negative number cells with the right mouse button, click on a cell and select 'Format Cells’ or press Ctrl + 1 (Windows) Y +1 (Mac).
2. Find the tab Números> Números negativos, in the left section.
3. Select the format you like best to highlight negative numbers.

NOTE: And, on the other hand, you want a custom format within the same numbers tab, at the end select custom.

With respect to Excel that enables you to count the negative range numbers:

• Go to a blank cell and put the formula formula = CONTAR.SI ($ A $ 1: $ B $ 5, ‘<0' (A y B son los rangos que desea utilizar)).
• To add all negatives from a single range, the formula is = SUMIF ($ A $ 1: $ B $ 5, ‘<0').

I can add columns from my spreadsheets

The easiest way to add all the values ​​from a column is by placing your cursor at the bottom of an empty cell of the column you want to add next:

1. Find the formulas tab and select the function autosuma Σ
2. Later, the entire column you had selected will be shaded and the function = SUM will appear.
3. Press Enter and you will automatically get the result.

However, in order to add two or more columns within a spreadsheet, should:

1. select an empty cell below the columns you want to sum.
2. Find the function Autosum in the functions tab
3. Now that the function = Sum already appeared you must choose and drag the mouse towards all the cells that you want to add to the summation so that they are shaded
4. In conclusion, select Enter to get the result.

Microsoft Excel can be used as a calculator

So you don't divert your attention looking for another device, calculator or in another web portal where you can perform your mathematical operations, if not that you keep all your attention in a single program so that you do not lose the thread; Excel makes it possible for you to use it as a calculator.

To perform simple operations like summar, subtract, multiply and divide values what do you need, just find an empty cell and write the sign = first number to add (followed by the sign +, -, *. /), second number to add (they can also be cells). As an example: = 155 * 3 and pressing Enter and you will have the result instantly.

Commonly Used Commands and Formulas in Spreadsheets

Apart from the function or formula and sum, there are many more functions where Standing out can make your life easier, What:

1. Subtract to subtract the values ​​you need = A2-A5.
2. Multiplication to multiply the values ​​you need with an asterisk symbol = A2 * A5.
3. Division to divide what is needed = A2 / A5.
4. The average, the mean or arithmetic mean of the cells you select = AVERAGE (A2: A5).
5. The maximum and minimum values ​​for a set of cells =MAX (A2, A5); MIN (A2, A5).
6. Counting is a formula for counting values (numerical) or the entries of a table. = COUNT (A2: A5).
7. To count if a series of items meet the established parameters = CONTAR.SI (A2: A5; “555”)
8. The condition allows a value to be returned if the parameter we configure is met: = YES (A2 = '300', 'Happens'; ‘It doesn’t happen’).
9. With the Find a value within the row function = VLOOKUP ('MARIA', A2: A5, 3, FAKE)if we want to know the number of cakes bought by Maria in the entry or table, and in terms of false to indicate that you do not select any other name that is Maria

Other digital tools to work with

Excel is undoubtedly one of the best calculation tools in the world. Despite this, require other alternatives such as Google Sheets with access from a Gmail account, ThinkFree, Apple Numbers, Gnumeric, Spread32, Zoho Sheet, BIRT and Quip.