Thread: COUNTIF cannot count decimal number occurences
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default COUNTIF cannot count decimal number occurences
Maybe you could just use:

=count(a1:a10)
to count the number of numbers.



Ignorasmus wrote:

Excel function COUNTIF cannot count decimal number occurences in an array.
Why? What to do?
Thanks

--

Dave Peterson
Reply With QuoteReply With Quote