count if with two references

[Jim]

I would like to count the number of times “Digital Cable appears in the Data
input example listed below if “Digital Cable†falls within the date options
listed in the Summary.

For example I would like the total times “Digital Cable†is sold between
12/5 and 12/11.

Thanks for the help.

Summary
Date # Contacts # Digital TVSold
Week One - 12/1 - 12/4 0
Week Two - 12/5 - 12/11 20

Data Input
Friday, December 09, 2005 Digital Cable Phone
Friday, December 10, 2005 Digital Cable Phone
Friday, December 20, 2005 Digital Cable Phone
Friday, December 15, 2005 Digital Cable Phone
Friday, December 08, 2005 Digital Cable Phone
Friday, December 06, 2005 Digital Cable Phone
Friday, December 04, 2005 Digital Cable Phone
Friday, December 12, 2005 Digital Cable Phone

 

[Bob Phillips]

=SUMPRODUCT(--(B2:B200="Digital
Cable"),--(A2:A200>=--"2005-12-01"),--(A2:A200<=--"2005-12-04"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)