View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peters Peters is offline
external usenet poster
 
Posts: 18
Default count number of occurances between 2 values

I am trying to count how many cells contain a number within a certain range
eg number of cells in a column that are between 1000 and 2000.
I thought i could write it like =countif (A1:A4, 1000 <2000) doesn't work
for me
A
1000
4502
1203
2308