If formula- can anyone help?

i'm having an utter nightmare remembering how to solve this

i have the following

value being a, date from b and date to c

Value  Date From     Date to
£5000   30/04/08    31/09/08
£2450   30/09/08    30/10/08
£7500   14/03/09    23/05/09
£9000   22/03/08    31/06/09

i wanna have a formula that works out how much relates to

07/08 year - being 01/04/07 to 31/03/08 say in column d
08/09 year - being 01/04/08 to 31/03/09 in e
and 09/10 year - being 01/04/09 to 31/03/10 and f

i'm sure i've done summat like this before and know that it will involve working out the values per day to start with

can anyone help?

Try

=Sumif(B:B,">=01/04/07",A:A)-Sumif(B:B,">31/03/08",A:A)

Not sure how you got your example results? What are you matching up?

My assumption is:

=SUMIFS($A$4:$A$7,$B$4:$B$7,">="&E$1,$C$4:$C$7,"<="&E$2) in E4 and copied down and across.

If you edited your Original Post with an attachement (I guess), then this is confusing.

I am confused on how you get this fractional amount?

I came up with this in E4. Drag Right and Down.

=$A4*(MIN($C4-$B4,MAX(0,E$2-$B4))/($C4-$B4)-MIN($C4-$B4,MAX(0,E$1-$B4))/($C4-$B4))

Small correction

=$A4*(MIN($C4-$B4,MAX(0,1+E$2-$B4))/($C4-$B4)-MIN($C4-$B4,MAX(0,E$1-$B4))/($C4-$B4))

Otherwise it come 1 day short. The TO date is including that day!

Excel or you? Both dates are at 00:00

14/03/09 00:00 and 23/05/09 00:00

There are 70 days in between !! If you like to include 23/05 then this would be 24/05/09 00:00 which is the same as 23/05/09 24:00

14/03/09 -14/03/09 = 0 and not 1

therefore I posted a correction

=$A4*(MIN($C4-$B4,MAX(0,1+E$2-$B4))/($C4-$B4)-MIN($C4-$B4,MAX(0,E$1-$B4))/($C4-$B4))

Another approach is to make 08/09 being 01/04/08 till 01/04/09.

This would be my preference