Count Multiple Criteria

  • Thread starter Thread starter Brian
  • Start date Start date
B

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!!!
 
=SUMPRODUCT(--(B2:B200>=TODAY()),--(C2:C200=""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top