Count Multiple Criteria
 

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!!!

Count Multiple Criteria
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brian" wrote in message
oups.com...
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!!!

Count Multiple Criteria
 

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