I am having trouble figuring out the spreadsheet bundle. Suppose I have the following table:
|name |foo |bar |total | |mike | 1 | 2 | |
How do I calculate the total?
From the screencasts, I think I should have this line:
% A3 := SUM(A1:A2)
Then what do I need to do to get the cell to display the value?
Mike
It had been so long since I used the bundle, that I actually had to reenable it ;)
So to return to the matter at hand, first of all numbers move you downwards, and letters move you to the right. So what you want is probably:
% D2 := SUM(B2:C2)
(Note, that A1 is "name", C1 is "bar" and so on.
Next, you just need the "execute document" command, bound to cmd-R.
On May 23, 2007, at 1:31 PM, Mike Mellor wrote:
I am having trouble figuring out the spreadsheet bundle. Suppose I have the following table:
|name |foo |bar |total | |mike | 1 | 2 | |
How do I calculate the total? From the screencasts, I think I should have this line:
% A3 := SUM(A1:A2)
Then what do I need to do to get the cell to display the value?
Mike
Haris Skiadas Department of Mathematics and Computer Science Hanover College