Seeing as you have different years, you might want to include the year test

=SUMPRODUCT(--(A1:A5="Brian"),--(YEAR(B1:B5)=2006),--(MONTH(B1:B5)=1),C1:C5)


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"JMB" wrote in message
...
Using your example data:

How many sales Brian had in January (2):
=SUMPRODUCT(--(A1:A5="Brian"),--(MONTH(B1:B5)=1))

The dollar value of those sales ($350):
=SUMPRODUCT(--(A1:A5="Brian"),--(MONTH(B1:B5)=1),C1:C5)


Modify as needed. Note 2/29/06 is not a valid date.

"Rolf" wrote:

A1_A5 Name Brian, Chris, Brian , Chris,
Brian
B1_B5 Date 1/1/2006, 2/15/2006, 1/15/2006, 2/29/2006, 2/3/2006
C1_C5 $ 100, 150 , 250, 95,
10

I Need
How many times Brian sold somthin in january (2) or Chris (0) in
february
Chris (2) brian (1)

How many Money January Brian (350) or Chris (0) in february Chris (245)
brian (10)

i like to use sumif ??? for the money and countif ????? for Sales but
i
dnt know the formulars. Ineed help
Thank You

Rolf