COUNTIF values are 0
 

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

COUNTIF values are 0
 

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

COUNTIF values are 0
 

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

COUNTIF values are 0
 

Thanks for the feedback, glad to be of help

oldchippy ;)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=571957