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?

SUMIF with more than one criteria
 

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?

SUMIF with more than one criteria
 

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