| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
THE FORMULA THAT I HAVE WILL COUNT ALL POSITIVE #'S IN RANGE AND
I KNOW THAT IF I CHANGE MY FORMULA TO READ =COUNTIF(D4  29,"<0") THIS WILLCOUNT ALL MY NEGATIVE #'S IN RANGE. BUT WHAT I NEED IS TO COUNT ALL #'S >0 AND <0 PLEASE HELP |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
How about =COUNTIF(D4 29,"<>0")-- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=561795 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Very non-robust. See my response in the earlier thread.
Jerry "Mallycat" wrote: > > How about =COUNTIF(D4 29,"<>0")> > > -- > Mallycat > ------------------------------------------------------------------------ > Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 > View this thread: http://www.excelforum.com/showthread...hreadid=561795 > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered | pmdoherty | Microsoft Excel Worksheet Functions | 4 | 6th Feb 2009 11:23 AM |
| can I nest COUNTIF functions(C5:C8,"apples") AND (D5:D8,"green") | guycummins | Microsoft Excel Worksheet Functions | 4 | 10th Jun 2008 09:23 PM |
| IF(COUNTIF(Thursday,"John Doe")>1,"error"," ") | jayd77 | Microsoft Excel Discussion | 2 | 27th Oct 2005 02:17 AM |
| Re: IF(COUNTIF(Thursday,"John Doe")>1,"error"," ") | jayd77 | Microsoft Excel Discussion | 0 | 27th Oct 2005 12:48 AM |
| Countif(a2:a10, "apples""pears""oranges") | =?Utf-8?B?QWRhbQ==?= | Microsoft Excel Misc | 5 | 3rd Nov 2004 06:37 AM |
