Hello,
This is my problem:

Column C has text values (Phone, Meeting)
Column F has dates (01/01/2006 - 08/31/2006)
but, Column F also has misc text ("*", ".", "?" or can be blank)
Column H has text values ("AA", "AA-1", "AA-2", ""BB")

I'm trying to find out how many "Phone" calls between 06/01/2006 and
07/31/2006

I'm trying to find out how many "Phone" calls where in the "AA" family
(includes "AA-1" and "AA-2")

When I was just looking for "Phone" and a number 39000 this worked:
{=SUM((C2:C200="Phone")*(F2:F20039000))}
The problem was I couldn't specify a date range, and it counted the other
characters.

Thank-you,
P.S. I learned a lot from the Pearson website