software

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

Hi April

One way
=COUNTIF(A:A,quot;gt;39quot;)-COUNTIF(A:A,quot;gt;60quot;)

--
Regards

Roger Govierquot;Aprilquot; lt;April @discussions.microsoft.comgt; wrote in message
...
gt;I need to find the number of times in which a value is reported between
gt;the
gt; range of 40-60. I need the formula for this type of calculation
hi,

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

=count(if((rangegt;40)*(rangelt;60),range))

Regards,

quot;Aprilquot; wrote:

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