10 June 2009
I have doubt in adding cell contents of a row in MS Excell
e.g I have total 1 2 3 4 5 6 7 8 9 10 From to Name * * * * * * * * * *
I want a formula so as to add cell contents as =SUM(from:end), WITHOUT giving direct cell reference, but want to give the reference as From: 1, To: 8 so that excell should make a total of data in the row from row"1" to row"8".
I want to have separate two cells where i could directly give these cell references