Thread: How do I use the count if function for a range from 40-60 ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur
 
Posts: n/a
Default How do I use the count if function for a range from 40-60 ?
hi,

You may try the following array formula (Ctrl+Shift+Enter)

=count(if((range40)*(range<60),range))

Regards,

"April" wrote:

I need to find the number of times in which a value is reported between the
range of 40-60. I need the formula for this type of calculation
Reply With QuoteReply With Quote