How do I use the count if function for a range from 40-60 ?

A

April

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
 
A

Ashish Mathur

hi,

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

=count(if((range>40)*(range<60),range))

Regards,
 
Top