Thread: best way to combine logical and countif
View Single Post
  #1   Report Post  
Dave H Dave H is offline
Member
  
Posts: 54
Default best way to combine logical and countif
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?
Reply With QuoteReply With Quote