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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Brian" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!!!
>

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