In a message dated 2010.09.01 23:03 -0500, NoOp 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 a 1xN matrix scalar product? 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.
Sorry, that was just stupid. I know to look for that, but got careless.
Thanks for mentioning it - hereby corrected.
Bob - sending this to your email, in case you miss seeing it in the OO
[discuss] list. If you want to follow up, please post to the list
rather than reply - and to maximize your returns you might want to join
the [users] list, and post questions like this one there.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
