View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NCINDASUN
 
Posts: n/a
Default Between? Is there a way?

I'd like to count the number of cells in a range whose value is between two
preset numbers. I would imagine that it would be something like

=countif(between(a1:a10,20,30))

but there doesn't seem to be a "between" function.

Can anyone help? Thanks