SUm

B

Bernard Liengme

Positive values only: =SUMIF(A1:A20,">"&0)
Negative values only: =SUMIF(A1:A20,"<"&0)
best wishes
 
F

Fred Smith

If it's the whole column you want to sum, use:
=sumif(a:a,">0")
=sumif(a:a,"<0")

Regards,
Fred.
 

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

Cumulative formula for word table 0
Program buttons to create a word document 0
Change the colour of a neighbouring cell 6
percentage calculation 4
Find and replace macro for Special ^p - MS Word 0
Sum function 3
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
If sign of sum is negative change to positive 1

Top