Thread: best way to combine logical and countif
View Single Post
  #2   Report Post  
wickedchew wickedchew is offline
Senior Member
  
Location: Philippines
Posts: 161
Default
Quote:
Originally Posted by Dave H View Post
I have a column of numbers and I would like to count them based on a range rather than specifc value. Is there a formula (easy way)?

For example I wish I could use =countif(a1:a1000,100)

Any ideas?
=countif(a1:a1000,"100")
Reply With QuoteReply With Quote