When do I go over budget?

[Cantona_lives]

Hi all,
Hopefully a fairly easy one.

Months across the top
A B C D M
Jan Feb Mar etc Budget
1 £1 £3 £4 £5


So if I spend £1 in Jan, £3 in Feb and then £4 in Mar - how do I calculate at which point my budget runs out? So in this case it would be Mar and I would also like the formula to calculate - "Mar by £3"

Thanks,


-CL

 

[palaeontology]

what is your budget ?

 

[Cantona_lives]

what is your budget ?

Apologies, my crude example did not format well. In the row under 'Budget' and in this example - £5.

Thanks,

-CL

 

[sheetspread]

Excel 2010
	A	B	C	D	E	F	G
1	Jan	Feb	Mar		Budget
2	1	3	4		5	Mar	by 3
Sheet28

Cell Formulas
Range	Formula
F2	{=INDEX($A$1:$C$1,MATCH(TRUE,MMULT($A$2:$C$2,--(COLUMN($A$2:$C$2)>=TRANSPOSE(COLUMN($A$2:$C$2))))>=E2,0))}
G2	{="by "&INDEX(MMULT($A$2:$C$2,--(COLUMN($A$2:$C$2)>=TRANSPOSE(COLUMN($A$2:$C$2)))),MATCH(F2,$A$1:$C$1,0))-E2}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Cantona_lives]

Thank you for the help, will implement, test and report back.


Thanks,
-CL