If Statements

[DeckyT]

Hi all,

I have three columns. In the three columns there are positive and negative
values. How do i sum across only positve values??

 

[Toppers]

Use SUMIF:

=SUMIF(A1:A20,">0")

HTH