COUNTIF values are > 0

[Guest]

How can I use COUNTIF to count the values in a range which are greater than 0?

I put =COUNTIF(B2:B100000)>0 but that didn't work?

(I'm using XL 2007 hence the range greater than 65000 rows. But I don't
think COUNTIFs syntax has been changed in 2007 so I assume I'm having a brain
fart.)

Thx,

Dave

 

[oldchippy]

How can I use COUNTIF to count the values in a range which are greater
than 0?

I put =COUNTIF(B2:B100000)>0 but that didn't work?

(I'm using XL 2007 hence the range greater than 65000 rows. But I
don't
think COUNTIFs syntax has been changed in 2007 so I assume I'm having a
brain
fart.)

Thx,

Dave

Hi Dave,

I'm still with 2003, but try this,

=COUNTIF(B2:B100000,">0")

oldchippy

 

[Guest]

Yeah that's it, thanks.

Hi Dave,

I'm still with 2003, but try this,

=COUNTIF(B2:B100000,">0")

oldchippy

 

[oldchippy]

Thanks for the feedback, glad to be of help

oldchippy