On 2002-02-21 13:16, Mark O'Brien wrote:
On 2002-02-21 12:53, MJA wrote:
Hello Mr. Excel,
I have a serie of numbers that can vary, the
serie always starts in A1 and can go till Ax.
In the cell next to Ax I want the total.
How do I do that?
I'm assuming you mean "Ax" to be, for example, "A10" or however many rows the "A" column occupies. So you're really wanting the total of a column, not the total of a row.
The most common suggestion here is to put the total at the top of a column. In this case, make "A1" the total. You could then put a formula
like :
<pre> =SUM(A2:A65536) </pre>
This way it doesn't matter how many rows you use.
HTH