View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] paffni@gmail.com is offline
external usenet poster
 
Posts: 2
Default Sum values within a specified date range

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.