Excel 2000 Formula

[Guest]

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.

 

[Roger Govier]

Hi Richard

Either
=COUNTIF(D487,">="&65%)-COUNTIF(D487,">="&80%)
or
=SUMPRODUCT((D487>=65%)*(D487<=80%))

 

[Guest]

Thanks Roger

That's exactly what I needed.