In a message dated 2010.08.31 21:21 -0500, Bob Runkel wrote:
How does one sum a series of columns?
=SUM(<column_range>). [Note the = prefix, if you are used to one of the
spreadsheet programs that does not require it.] If you mean to sum all
of the column totals, then
=SUM(row_range)
if all totals are in the same row, otherwise
= column_A_total + column_B_total + column_C_total + ...
[Note that you can name any or all of the totals, but I use the terms
"column_x_total" generically.]
Also, Ho does one multiply two columns?
Do you mean the scalar product of a matrix? If so, SUMPRODUCT() could
be what you are talking about. If not, post again.
John
---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-unsubscr...@openoffice.org
For additional commands, e-mail: discuss-h...@openoffice.org