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")
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")
Last edited: