ExcelBanter - best way to combine logical and countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - best way to combine logical and countif (https://www.excelbanter.com/excel-discussion-misc-queries/265424-best-way-combine-logical-countif.html)

Dave H

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?

wickedchew

Quote:

Originally Posted by Dave H (Post 958827)

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")

All times are GMT +1. The time now is 01:53 PM.