count if with two references
 

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

count if with two references
 

=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)

"Jim" wrote in message
...
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