how to add only positive number

mangesh · Mar 6, 2004

hi
i have a column which has positive as well as negative number but
would like to add only positive number, how do i,
please let me kno

Frank Kabel · Mar 6, 2004

Hi
try
=SUMIF(A1:A100,">0")