View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default count number of cells in range showing between 320 and 345

You could also use two countif functions:
=countif(A:A,"320")-countif(A:A,"=345").
The first countif tallies up those entries that are over 320; the second
backs out those at least 345, leaving only those between 320 and 345.

"annieandtika" wrote:

What formula do I use to count the numbers of cells in a range which return a
value of greater than 320 and less than 345?