Hi
I have a amounts in range a1:a200. Some are negative amounts and some are positive amounts. I need the sum of all negatives in b1 and sum of all positives in c1.
can someone help me to fix the formula..
Thanks
Hi
I have a amounts in range a1:a200. Some are negative amounts and some are positive amounts. I need the sum of all negatives in b1 and sum of all positives in c1.
can someone help me to fix the formula..
Thanks
Last edited by SMILE; 08-28-2011 at 03:31 AM.
=sumif(a1:a200,"<0") for neg
=sumif(a1:a200,">0") for pos
Thank u arthurbr... I did not put a "" for <0. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks