Sample Document

   Hi ! Here Suggest to you

Nice Question Thanks. DataSheet= SampleDoctment
1  2  3  4  5  6  7  8	A B C D E SampleDosumentMaking Month Section1 Section2 Section3 Max Jan 500 600 400 600 Feb 600 700 600 700 Mar 700 800 800 800 Apr 800 900 1,000 1000 May 900 1,000 1,200 1200 Summary 3,500 4,000 4,000

Used Formula ...(With Running MicrosoftExcel Ver 2003)
No	Addr'	If use below Formula, You'll Get Result as Right	Result	Etc
1	E3	=MAX(B3:D3)	600
2		E3  His Formula Used This Cell  -> E3:E7
3	B8	=SUM(B3:B7)	3,500
4		B8  His Formula Used This Cell  -> B8:D8
How about this suggest?