Saturday, October 17, 2009

Summing Multiple Table Cells

1. Select the cell want to enter the Sum equation
2. Formatting toolbar - Formula - Sum

3. Define a window around the cells that want to include in the sum formula

Average: =AVERAGE(A1:A5)
Count: =COUNT(A1:B5)
Cell: =Table(2130477568).A5
Returns value of cell in another table
The number in parentheses is the object identifier for the other table
Equation: = A1*A5

No comments:

Post a Comment