Thread: Count numbers and non numbers(conditional values)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ecoman Ecoman is offline
external usenet poster
  
Posts: 3
Default Count numbers and non numbers(conditional values)
It works for some of the data, however I have values of <0.5 that get
included as part of this formula.

Thank you for the quick response.


"Gary''s Student" wrote:

=COUNTIF(A1:G1,""&3.7)+COUNTA(A1:G1)-COUNT(A1:G1)

--
Gary''s Student - gsnu200785
Reply With QuoteReply With Quote