Hello,

I am trying to count the number of occurrences
a text based instance occurs
within a date range
based upon the text found within the Activity.

So for example, I have a Sales Report Sheet with the following
activity per rep.

Date    Rep        Activity Title
Jan 1    Sally Sue    Voice Mail
Jan 3    Bob Greene    Voice Mail
Jan 3    Sally Sue    Talked to George
Jan 10    Bob Greene    Talked to Kim
Feb 1     Sally sue    Voice Mail
Feb 10    Sally Sue    Talked to Steve

I would like to run a formula that will tell me
all occurrences of "Bob Greene",
Left Voice mail, in January.

all occurrences of "Bob Greene",
Left Voice mail, in February

AND

all occurrences of "Bob Greene",
and "Bob Greene" with "talked to", in January.

all occurrences of "Bob Greene",
Left Voice mail, in February

I think I need to run a "conditional if", however have no idea how to
do text based searches.

Can anyone help.

Thanks!