COUNTIF values are > 0

Originally Posted by Dave F

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

Yeah that's it, thanks.

"oldchippy" wrote:

>
> Dave F Wrote:
> > 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
>
>
> --
> oldchippy
> ------------------------------------------------------------------------
> oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
> View this thread: http://www.excelforum.com/showthread...hreadid=571957
>
>

Thanks for the feedback, glad to be of help

oldchippy