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