Excel question??

[DampDog]

I have a column that is a mix of positive and negative numbers. Is there a way that I can sum the column but have it not include the negative numbers.

My Google-fu has failed me..

Sorry cancel that, I've sussed it. I was just missing a comma from the function I was using.

=SUMIF(A16:A40,">0")

 

[Zefan]

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

:edit: Ha, I typed it, went to test it to be sure, posted it, then saw your edit

 

[DampDog]

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

:edit: Ha, I typed it, went to test it to be sure, posted it, then saw your edit

Cheers anyway. I found the formula straightaway but just couldn't get it to work. Then twigged I'd not been putting the comma in.