Email address obfuscation in effect -- please
click here to turn it off.
[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
On Thu, 8 Nov 2007, Mike Miller wrote:
On Thu, 8 Nov 2007, Jonathan King wrote:
The answer is in the handy "indirect" function. So let's assume a1 has
the ending row number, b is the row to sum (from b1) and c1 is where
you want the formula to pop up. Then what you want in c1 is:
=sum(indirect("b1:b"&a1))
That is fantastic. Thank you!!
I wonder if it works the same in Calc. I will be finding out soon
enough.
Yep. The entire spreadsheet imports neatly into Calc and works perfectly.
Excel is just a touch faster than Calc. What I'm doing runs very fast but
you can still tell the difference. The beauty of calc for this
application is that anyone can run it for free on nearly any computer
system (Windows, Linux, MacOS X, Solaris, FreeBSD).
Mike
_______________________________________________
discussion mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/discussion
Home | FAQ | Server | Presentations | Mailing Lists/Archives | Member Tools | Links | Sponsors | Contact