Sum values within a specified date range

P

paffni

Please help.

( Sheet 1 ) ( Sheet 2 )
Value Paid Cut-off from Cut-off to Will receive in: SUM
245,94 20.09.2006 21.08.2006 20.09.2006 October ?
243,67 02.11.2006 21.09.2006 20.10.2006 November ?
200,00 27.09.2006 21.10.2006 20.11.2006 December ?

I have 2 sheets - one with invoice details and the second sheet should
calculate the values of the invoices within a certain period.
I need to create a formula that will evaluate invoice paid dates (Paid)
and if it is within certain cut-off period (Cut-off from - Cut-off to)
it will summ all the values (Value) within this period.
I try to use SUMIF function but I can not make it work.

Thank you.
 
B

Bob Phillips

=SUMPRODUCT(--(Sheet1!$B$2:$B$20>=Sheet2!A2),--(Sheet1!$B$2:$B$20<=Sheet2!B2),
Sheet1!$A$2:$A$20)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top