calculate amount deepening on month

[thedontron]

hello there

i have a file with 2 sheet as below and i need to calculate X.

the way i want to do it is that when i change the month Cell the formula must calculate previous result + the new month
so if i calculate apples for June and July total is 25, plus August, formula should give 45

i have to following

Sheet one

Month	8
Apples	X
Orange	X

<tbody>
</tbody>

Sheet 2

	June	July	August
Apples	10	15	20
Orage	20	25	30

<tbody>
</tbody>

Please let me know if it is not clear

thank you

 

[jim may]

Try this... (In Sheet1)

Excel 2012
	A	B	C
1	Month	June	<< Type In Last Month Name Desired (not the numeric eqivalent).
2	Apples	10
3	Orange	20
Sheet1

Cell Formulas
Range	Formula
B2	=IFERROR(SUM(Sheet2!$B2:INDEX(Sheet2!$B2:$D2,,MATCH(Sheet1!$B$1,Sheet2!$B$1:$D$1,0))),"")
B3	=IFERROR(SUM(Sheet2!$B3:INDEX(Sheet2!$B3:$D3,,MATCH(Sheet1!$B$1,Sheet2!$B$1:$D$1,0))),"")