I have a column (c) with dates...I have column (ba) with text data, sometimes
RIEP sometimes Charged with (some type of crime). I want to have excel add
up the total occurrances of RIEP between 2 dates (ie quarter 1 = 1/1/2006 -
3/31/2006). I am able to do this with the following formula. I then want
excel to add up the occurances of Charged. I have tried to insert
"Charged*" ,but this does not work. Is there a better formula for this type
of action?? I have to havce a variable because I want to be able to have
data such as Charged with VOCSL-1 Charged with VOCSL-1 charged with......
what ever....

=SUMPRODUCT(--(CaseData!$BA$2:$BA$1000="RIEP")*--(CaseData!$C$2:$C$1000=--"2006-01-01")*--(CaseData!$C$2:$C$1000<=--"2006-03-31"))