sumif between 2 days

E

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 hav
tried everything but nothing works! I using a dutch version of Excel s
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
 
W

widemonk

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

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

Peo Sjoblom

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