SUMIF with more than one criteria

[Guest]

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?

 

[Guest]

Hi
you can use "SUM(IF" array function. If you are not clear, please do mail to
(e-mail address removed) with your criteria or post your criteria here.

 

[SteveG]

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 date
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 {} aroun
the formula.

HTH

Stev