View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Craig Craig is offline
external usenet poster
 
Posts: 208
Default Calculating data between two given parameters

If i have a range of A1:A300 and the range of numbers within those cells
could be anything from 1 to 50 how do i count cells that contain numbers
greater than 20 but less than 31?

Thanks