Help on Excel 2007

This query is : Resolved

PRANAV (Querist)
Follow

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

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Summarize this with AI

ChatGPT Perplexity Claude Google AI Grok