Sum of row and column entries (database)
If you've got your X values in row 1 in B1 to F1, and your Y values in
column A in A2 to A6, then in cell B2 insert the formula =B1+A2. Then copy
that cell to the other cells down and across your range.
--
David Biddulph
wrote in message
...
Hi newsgroup,
I was wondering whether anyone knows a formula that does the
following:
I have a number of values in a column and row of a large database that
i want to sum automatically, as in the following example:
x1 x2 x3 x4 x5
y1 (x1+y1) (x2+y1) (x3+y1) (x4+y1) (x5+y1)
y2 (x1+y2) (x2+y2) (x3+y2) (x4+y2) (x5+y2)
y3 (x1+y3) (x2+y3) (x3+y3) (x4+y3) (x5+y3)
y4 (x1+y4) (x2+y4) (x3+y4) (x4+y4) (x5+y4)
y5 (x1+y5) (x2+y5) (x3+y5) (x4+y5) (x5+y5)
I think I might solve this with a Pivot table, but I have very little
knowledge of pivots...
Thanks a lot and best regards,
Chris
|