Thread: count number of cells in range showing between 320 and 345
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
annieandtika
 
Posts: n/a
Default count number of cells in range showing between 320 and 345
Hi - thank you so much for replying but I still can't seem to make it work.
Excel keeps correcting the formula.

"Gary''s Student" wrote:

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?

Reply With QuoteReply With Quote