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
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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=562819