How to add only positive numbers

If necessary, add up to only a positive or only negative numbers, you can sort them depending on the sign and then to implement the operation of addition. But if the array is large or the operation has to be repeated frequently, this procedure usually trust programs compiled using any of the programming languages. The table editor Microsoft Office Excel allows to solve this problem without programming knowledge.

How to add only positive numbers
How to round numbers in Excel - different ways
How to sum in Excel
How to write formula in Excel

You will need

The table editor Microsoft Office Excel

Instruction

Start Microsoft Excel and type in an empty cell of the table an array of values positive number which needs to be folded. This can be done manually, but if it is possible to copy all the array data in text format, it will be much easier to insert it into the table, pre-slightly changing the format. If the number in the text containing the source values, separated by spaces, then perform with any text editor replace all spaces with tabs. After this operation, copy the text numbersand paste it into Excel - numbers will be placed in the cells of one row. If you replace the spaces with the signs of the end of the row, when you paste in spreadsheet editor numbers will line up in the column.

Enter the formula that performs the summation of the range of cells with pre-specified test conditions. To do this, select the table empty cell in which you would like to put the result of the calculation, and click the icon insert function - it is in the beginning of the formula bar above the table. This way you start the function wizard, which helps make up the formula online.

Open the drop-down Category list and select "Math". In the list of functions this section to find the one which is called SUMIF - click it and click "OK" to proceed to the next step.

Specify arguments that should be passed to this function. First in the field "Range" you have to specify the start and end cell of the entered data. The easiest way to do this by highlighting the entire cell range with the mouse - in this case, the wizard will enter the desired values in the appropriate field. Then under Criteria, specify the condition that the formula shall select sum values. For addition of positive numbers, set the criteria to >0 and press the tab key. The third field ("Diapazonului") leave blank.

Press "OK" and Excel will put in the cell the formula is designed to calculate the value in accordance with it.

Is the advice useful?