View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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