i have a worksheet:

A_____________________B
10-jan-05___________23.93
11-jan-05___________1.23
12-jan-05___________12.95
23-feb-05___________25.95
24-feb-05___________124.32
22-nov-05___________34.32
23-nov-05___________23.32
01-nov-05___________10.02
02-nov-05___________1.95
01-dec-05___________23.32
02-dec-05___________74.04
05-dec-05___________85.90

now i want the sum of the values in B of the month november! I have tried everything but nothing works! I using a dutch version of Excel so the functions are translated but one of my functions looks like this:

SUMIF(A1:A20, AND(">=01-11-2005", "<=31-10-2005"), B1:B20)

Who can help me!