Excel 2000 Formula
 

I am using Excel 2000 and I am trying to create a formula that does the
following:

If cells D4 to D87 have values that range from 45% to 100%, how do i put a
formula in E78 that counts the number of cells with values <80% and =65%

Many thanks in advance.

--
Richard

Excel 2000 Formula
 

Hi Richard

Either
=COUNTIF(D4:D87,"="&65%)-COUNTIF(D4:D87,"="&80%)
or
=SUMPRODUCT((D4:D87=65%)*(D4:D87<=80%))

--
Regards

Roger Govier


"Richard" wrote in message
...
I am using Excel 2000 and I am trying to create a formula that does the
following:

If cells D4 to D87 have values that range from 45% to 100%, how do i
put a
formula in E78 that counts the number of cells with values <80% and
=65%

Many thanks in advance.

--
Richard

Excel 2000 Formula
 

Thanks Roger

That's exactly what I needed.
--
Richard


"Roger Govier" wrote:

Hi Richard

Either
=COUNTIF(D4:D87,"="&65%)-COUNTIF(D4:D87,"="&80%)
or
=SUMPRODUCT((D4:D87=65%)*(D4:D87<=80%))

--
Regards

Roger Govier


"Richard" wrote in message
...
I am using Excel 2000 and I am trying to create a formula that does the
following:

If cells D4 to D87 have values that range from 45% to 100%, how do i
put a
formula in E78 that counts the number of cells with values <80% and
=65%

Many thanks in advance.

--
Richard