MrExcel Publishing
Your One Stop for Excel Tips & Solutions

find all negative numbers in a range and total them


Posted by w king on February 11, 2002 7:55 AM


I have a range of cells and if there is a negative number in a cell I want it to be added to a total number of negative # cells. I want to add up the total number of cells, not the total of the values in these cells and place that value in another cell.
Thanks,
W.


Posted by Aladin Akyurek on February 11, 2002 8:03 AM

=COUNTIF(A1:A5,"<0") [NT]

Posted by w king on February 11, 2002 8:29 AM

Re: =COUNTIF(A1:A5,"<0") [NT]

Works great! Now can you show me how to make this work with the following range A34:A55,O34:O55
Thanks,
W.

Posted by Aladin Akyurek on February 11, 2002 8:37 AM

Counting over non-consecutive ranges

=COUNTIF(A34:A55,"&LT;0")+COUNTIF(O34:O55,"&LT;0")

=======