Aladin

In your response (reproduced below) :-

=SUM(SUMIF(A1:A2,{"0","<0"}))

Would you still need the sum() before the sumif? Wouldn't sumif() do
the sum of the cells A1 and A2 if the condition is met?


Best regards


Deepak Agarwal


--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345
View this thread: http://www.excelforum.com/showthread...hreadid=384426