thedontron
New Member
- Joined
- Mar 26, 2014
- Messages
- 30
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Orage[/TD]
[TD]20[/TD]
[TD]25[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Please let me know if it is not clear
thank you
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Orage[/TD]
[TD]20[/TD]
[TD]25[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Please let me know if it is not clear
thank you