Simple Question

  • Thread starter Thread starter adrianbarnes.com
  • Start date Start date
A

adrianbarnes.com

Cells D6:D88 contains target scores, cells F6:F88 contains actual
scores. I want a formula in F89 that counts the number of instances
that the F cell is less than the D cell for the entire range of F6:F88.

Any help is appreciated...
 
=SUMPRODUCT(--(D6:D88>F6:F88))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Back
Top