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.
( 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.