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

You can use the SUMPRODUCT() function.
--
Gary''s Student


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