=sumproduct(--(text(a2:a6,"yyyymm")="201002"),--(b2:b6="John"),(c2:c6))

Or, a Pivot Table.

Regards,
Fred

"nordiyu" wrote in message
...
my condition is :
A B C
1 Date Name $
2 15/2/10 John 15
3 16/2/10 Mike 8
4 28/2/10 John 21
5 01/3/10 John 10
6 05/3/10 Mike 15


What the formula to get total $ John in month feb. / mar

Name Total $ Feb Total $ Mar
John ? ?



Rgds,