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
|