sumif between 2 days

[erwt]

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!

[widemonk]

Have a third column with the formula =MONTH(A2) and fill it down.

Then its =SUMIF(C1:C12,11,B1:B12)

[Peo Sjoblom]

=SUMIF(A1:A20,">"&DATE(2005,10,31),B1:B20)-SUMIF(A1:A20,">="&DATE(2005,11,1)
,B1:B20)


--

Regards,

Peo Sjoblom

"erwt" <[email protected]> wrote in message
news:[email protected]...
>
> 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!
>
>
> --
> erwt
> ------------------------------------------------------------------------
> erwt's Profile:
http://www.excelforum.com/member.php...o&userid=26993
> View this thread: http://www.excelforum.com/showthread...hreadid=484871
>