Sum only positive numbers in column

[rlnye]

I have a spreadsheet set up to monitor my stock transactions and would like a formula to sum on the positive numbers in a column. I have tried the IF function in vain...can you please help...thanks.

 

[Asala42]

Why not Sumif?

 

[Al Chara]

=SUMIF(A:A,">0") will sum all positive integers in column A

 

[rlnye]

thanks a bunch...much appreciated

 

[Chris Davison]

On 2002-04-08 13:07, Al Chara wrote:
=SUMIF(A:A,">0") will sum all positive integers in column A

Hi Al,

positive values, isn't it ? not just integers...

no offence, I'm just making sure !

Cheers
Chris