COUNTIF values are

COUNTIF values are > 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave F - 15 Aug 2006 21:55 GMT

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

Reply to this Message

oldchippy - 15 Aug 2006 22:05 GMT

Dave F Wrote:

> How can I use COUNTIF to count the values in a range which are greater
> than 0?
[quoted text clipped - 10 lines]
>
> Dave

Hi Dave,

I'm still with 2003, but try this,

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

oldchippy :)

Signature

oldchippy

Reply to this Message

Dave F - 15 Aug 2006 22:55 GMT

Yeah that's it, thanks.

> Dave F Wrote:
> > How can I use COUNTIF to count the values in a range which are greater
[quoted text clipped - 18 lines]
>
> oldchippy :)

Reply to this Message

oldchippy - 16 Aug 2006 08:56 GMT

Thanks for the feedback, glad to be of help

oldchippy ;)

Signature

oldchippy

Reply to this Message