Using Excel, how does one sum the values in all the cells of a group of cells in rows and columns which have values greater then zero (positive) into a total sum of the positive values, and separately sum the cells in the same group which have values less than zero (negative) into a total of the negative values to obtain separately the resulting positive and negative sums displayed in two separate cells?

Does one write the formula in CountIf or some other formula type?

`>`

and one will use`<`

. Give it a try and if you run into problems, post back with the problem (sample data, your formula, and what result you're getting).`<`

and`>`

needs to be wrapped into double quotes. So for example, in range`A1:B5`

with both negative and positive values, the`SUMIF`

would look like:`=SUMIF(A1:B6,">0")`

for positive values, and`=SUMIF(A1:B6,"<0")`

for negative.