Something like this:

=SUMPRODUCT(--(DATE(YEAR($A$2:$A$21),
MONTH($A$2:$A$21), 1) = DATE(2009, 11, 1)), --($M$2:$M$21="Jerry"),
--($G$2:$G$21<$O$2:$O$21))

Or:

=SUMPRODUCT(--(DATE(YEAR($A$2:$A$21),
MONTH($A$2:$A$21), 1) = DATE(2009, 11, 1)),
($M$2:$M$21="Jerry")+($N$2:$N$21="Jerry"), --($G$2:$G$21<$O$2:$O$21))

Does that help?

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"GPearson" wrote:

Hello:

I am working on a spreadsheet that records inventory. I need to create a
formula that counts if any items were completed late by a person . The
information regarding the person is recorded in one of two columns (M and N).
The date completed is recorded in column O. The due date is column G. I
also need to record this for each month received. The received date is
column A. So for example, I need to know how many items received in November
2009 and assigned to J. Smith were completed after the due date.

Thanks for any help you can give!