sumif

[rodeo]

Ok, I'm frustrated. I need to sum values in column "A" if values in column
"B" are during the month of "January" formated as a DATE (1/1/2008)

I have tried variations of SUMIF
((B2:B4=">=date(2008,1,1)")*(b2:b4)="<=date(2008,1,31))*a:2:a4)

And can't get it to work. What I actually have is a column of expenses and
another column with their associated dates. I want to know how much was
spent each month without putting in a summing line at the end of each month.
Does that make sense? Thanks for any help.

 

[David Biddulph]

=SUMPRODUCT((B2:B4>=DATE(2008,1,1))*(B2:B4<=DATE(2008,1,31))*(A2:A4))

 

[Don Guillett]

=sumproduct((month(b2:b22)=1)*a2:a4)

 

[Don Guillett]

=sumproduct((month(b2:b22)=1)*a2:a4)
=sumproduct((month(b2:b22)=1)*a2:a22)