software

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/40
Week Two - 12/5 - 12/1120

Data Input
Friday, December 09, 2005Digital CablePhone
Friday, December 10, 2005Digital CablePhone
Friday, December 20, 2005Digital CablePhone
Friday, December 15, 2005Digital CablePhone
Friday, December 08, 2005Digital CablePhone
Friday, December 06, 2005Digital CablePhone
Friday, December 04, 2005Digital CablePhone
Friday, December 12, 2005Digital CablePhone=SUMPRODUCT(--(B2:B200=quot;Digital
Cablequot;),--(A2:A200gt;=--quot;2005-12-01quot;),--(A2:A200lt;=--quot;2005-12-04quot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Jimquot; gt; wrote in message
...
gt; I would like to count the number of times quot;Digital Cable appears in the
Data
gt; input example listed below if quot;Digital Cablequot; falls within the date
options
gt; listed in the Summary.
gt;
gt; For example I would like the total times quot;Digital Cablequot; is sold between
gt; 12/5 and 12/11.
gt;
gt; Thanks for the help.
gt;
gt; Summary
gt; Date # Contacts # Digital TVSold
gt; Week One - 12/1 - 12/4 0
gt; Week Two - 12/5 - 12/11 20
gt;
gt; Data Input
gt; Friday, December 09, 2005 Digital Cable Phone
gt; Friday, December 10, 2005 Digital Cable Phone
gt; Friday, December 20, 2005 Digital Cable Phone
gt; Friday, December 15, 2005 Digital Cable Phone
gt; Friday, December 08, 2005 Digital Cable Phone
gt; Friday, December 06, 2005 Digital Cable Phone
gt; Friday, December 04, 2005 Digital Cable Phone
gt; Friday, December 12, 2005 Digital Cable Phone
gt;