Count Multiple Criteria

[Brian]

I have the following example of data.

Quote # Due Date Submital Date
6-0001 1/10/2006 1/17/2006
6-0002 1/13/2006 1/17/2006
6-0003 1/13/2006 1/17/2006
6-0004 1/6/2006 1/6/2006
6-0005 1/13/2006 1/18/2006
6-0006 1/12/2006 1/13/2006
6-0007 1/20/2006
6-0008 3/20/2006

I'm trying to get a count of Not yet submitted (blank cells) that are
late. And a count of Not yet submitted (blank cells) that are not late.
I've been trying to get it to work correctly using, sumproduct, sum,
sumif, count, countif but haven't been able to get it to work
correctly.

Thanks for any help!!!

 

[Bob Phillips]

=SUMPRODUCT(--(B2:B200>=TODAY()),--(C2:C200=""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Brian]

I swear I did that before. Whatever - it works. Thank you so much!