Just as with the example a gave it works as long as you enter a value in cell
A1 that makes sense. If you put in a value that is larger than the range you
want to total you might get an unexpected sum. This would be the case if you
have a total of the row in column 4 or 5. Also if you enter a zero in A1 you
get an error-message.
Arnold Huzen
Barrie Backhurst wrote:
> Bit late but here's an alternative
>
> =SUM(INDIRECT("A2:" & ADDRESS(2;A1)))
>
> Barrie
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
