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
|