Prev: Date formula
Next: how do i calculate a %
From: Keith on 15 Feb 2010 19:03
Take 2 - I don't think my first request got sent.

I am attempting to count the number of cells in AB2:AB26 that have a number
less thn zero. I have attempted this formula without success:

=COUNTIF(AB2:AB26,<0)

From: Max on 15 Feb 2010 20:11
=COUNTIF(AB2:AB26,"<"&0)
--
Max
Singapore
---
"Keith" wrote:
> Take 2 - I don't think my first request got sent.
>
> I am attempting to count the number of cells in AB2:AB26 that have a number
> less thn zero. I have attempted this formula without success:
>
> =COUNTIF(AB2:AB26,<0)
>
From: Ashish Mathur on 15 Feb 2010 20:43
Hi,

try this

=COUNTIF(AB2:AB26,"<0")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Keith" <oldpos(a)internode.on.net> wrote in message
news:75D987E4-B730-4572-B7E6-E244DC46713F(a)microsoft.com...
> Take 2 - I don't think my first request got sent.
>
> I am attempting to count the number of cells in AB2:AB26 that have a
> number less thn zero. I have attempted this formula without success:
>
> =COUNTIF(AB2:AB26,<0)

 | 
Pages: 1
Prev: Date formula
Next: how do i calculate a %