How to add several values that can be negative or positive, and accumulate later in separate variables

Question

Good Afternoon to everybodyHow to add several values ​​that can be negative or positive, and keep accumulating the Positive values ​​in one variable and the Negative ones in another variable? My task will go through a column in Excel that can have as many positive and negative values ​​in the same column. I have to go accumulating the negative and positive values, adding them up and obtaining in the final variables, the "accumulated" value, of the positive values ​​and the negative values.

karthik CN · Answer

@interplan if you want to get the sum of Positive and negative numbers in an excel Column you can can try this code. it does the same

Open Excel file
Loop through the column you want to get sum of +ve or -ve numbers
check if the Current value of a loop is -ve number Using String Include Condition
inside if or else you can add get the sum of the current value + Previous sum

Reply

Sign up

Login to the Pathfinder Community

Scanning file for viruses.

This file cannot be downloaded