Help with SUMIF

[Dale]

Hello,

I am fairly new to Excel and I need some help with the SUMIF function.
I have two columns, in Column A I have a list of dates. In Column B I
have a list of values. How do I write the SUMIF function to sum the
total of column B for dates in a specific quarter. (i.e. Jan thru Mar)
and exclude the the values for the other dates. I can get the function
to give me everything less then a specific date or great then a specific
date, however I am unable to get the result between two dates. Any help
would be greatly appreciated.
Column A Column B
01/01/04 5
02/05/04 4
03/10/04 1
09/04/04 6

Expected result would be 10

 

[Kieran]

Why not combine the two formulas you have already.

The count for a quarter = (sum of all dates greater than or equal t
the start of the quarter) - (sum of all dates greater than the end o
the quarter

 

[Frank Kabel]

Hi
one way:
=SUMIF(A1:A100,">=" &
DATE(2004,1,1),B1:100)-SUMIF(A1:A100,">="&DATE(2004,4,1),B1:B100)

or try:
=SUMPRODUCT(--(A1:A100>=DATE(2004,1,1)),--(A1:A100<DATE(2004,4,1)),B1:B
100)