Simple Question

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...
 
B

Bob Phillips

=SUMPRODUCT(--(D6:D88>F6:F88))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to increment cell formula by 5 rather than 1 7
Clear cell numbers using a macro - Help! 2
CONDITIONAL FORMATTING QUERY 0
Lookup multiple cell values and place contents in a single cell 3
Create if partial match then copy and paste data from one cell to another 1
Countif cell if other cells match criteria 3
=SUMPRODUCT question 1
IF function question 4

Top