On 09/01/2010 06:36 PM, John Kaufmann wrote: > 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
He can't hear you John... he's not subscribed. --------------------------------------------------------------------- To unsubscribe, e-mail: discuss-unsubscr...@openoffice.org For additional commands, e-mail: discuss-h...@openoffice.org