SUMIF with more than one criteria

This should be easy....

Payment Date Amount
03/01/06 £55.00
04/02/06 £60.00
21/01/06 £40.00
15/02/06 £24.00
04/01/06 £17.00

I want to create a week by week report where if the dates in column A fall
between 2 dates then it adds up the amount paid that week, but I'm struggling
to get SUMIF to work with 2 criteria. any Ideas?

Hi
you can use "SUM(IF" array function. If you are not clear, please do mail to
mohdraf@hotmail.com with your criteria or post your criteria here.



"EJ" wrote:

> This should be easy....
>
> Payment Date Amount
> 03/01/06 £55.00
> 04/02/06 £60.00
> 21/01/06 £40.00
> 15/02/06 £24.00
> 04/01/06 £17.00
>
> I want to create a week by week report where if the dates in column A fall
> between 2 dates then it adds up the amount paid that week, but I'm struggling
> to get SUMIF to work with 2 criteria. any Ideas?

EJ,

You could use SUMPRODUCT,

=SUMPRODUCT((A1:A10>=H1)*(A1:A10<=H2)*(B1:B10))

Where H1 is your start date and H2 is your end date. A1:A10 your dates and B1:B10 your values to sum. Otherwise use the array formula,

=SUM(IF(A1:A10>=H1,IF(A1:A10<=H2,B1:B10,0)))

Commit with Ctrl-Shift-Enter not just enter. This will put {} around the formula.

HTH

Steve