One way:

=SUMPRODUCT(--(A1:A1000="Sally"),--(MONTH(B1:B1000)=5))

See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation.

OTOH if you want to see the breakdowns simultaneously, I'd recommend a
Pivot Table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


In article ,
Thank you, Heath <Thank you, wrote:

How do you code the following situation:

countif(AND, logic1, logic2, logic3)

meaning I want it to count all of the occurances within three different
coloums of data.
Example: If Sally has a Doctors appointment in March, or If Mark has a
Tennis appointment in June, or if Bob has a dentist appointment in August. So
I want to be able to ask, how many doctors appointments does Sally have in
May? Or how many dentist appointments does Bob have in July.