Yes, your formula is better that way. I suspect from the original
posting that Kirill S Palagin wants to use a larger range than A2:C2, in
which case any formula involving a recitation of possibilities becomes
very cumbersome.
If you wanted to guard against a faulty entry in A1, you could preface
one of the other formulas with an IF statement:
=IF(A1<1;"";<main formula>)
It is interesting to consider the different approaches which are
possible - something you miss when working on your own.
arnold huzen wrote:
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]
Send instant messages to your online friends http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
