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?