sum up two result in one column

L

Lowan Chan

How can I sum up numbers which are >0 and <0 respectively in one column?
e.g. in Column A, I have

12
-46
90
32
-56
-34

how can I set the fomula that only minus number are sumed up?

thanks.
 
R

RonaldoOneNil

Assuming your numbers are in A1 to A6
=SUMIF(A1:A6,"<0",A1:A6)
=SUMIF(A1:A6,">0",A1:A6)
 
S

Stefi

=SUMIF(A1:A6,"<0",A1:A6) for negative,
=SUMIF(A1:A6,">0",A1:A6) for positive numbers.

Regards,
Stefi

„Lowan Chan†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum parts of a column 2
Numbers showing Up Centered in Cell ? 1
Variable row number in Sum($A$1:A10) formula 3
Sum a range based on a column 2
How to change a sum to an actual number I can paste into a new do. 4
Sum Total 2
Count occurrences when two conditions are met 1
Sum up cells in column A that has same text in Column B. 4

Top