On Jul 12, 12:21*am, John C <johnc@stateofdenial wrote:
Please be more clear. Still unsure what you are getting at. Are you saying
that the value to be displayed, for example, in K8 is NOT dependent solely on
the values in cells A through F only row 8? If that is the case, then the
SUMPRODUCT method mentioned would work for you....

--
John C



"robzrob" wrote:
On Jul 11, 11:57 pm, John C <johnc@stateofdenial wrote:
Assuming data starts in row 2, type the following in cell K2:

=(A2*B2)+(C2*D2)+(E2*F2)

Then Edit--Fill--Down as needed.

--
John C

"robzrob" wrote:
I don't suppose this is possible, but...

K12, K13, etc for about 10 rows need to be totals, totals of several
subtotals consisting of (A X B) + (C X D) + (E X F) + ... *Do I have
to have a seperate set of cells to calculate each (A X B) + (C X D) +
(E X F) + ... for each K cell or can I somehow link each K cell to a
place where each A, B, C, etc can be input and then get each subtotal,
ie (A X B) + (C X D) + (E X F) + ... for each K cell to appear in each
K cell? *(Long sentence - sorry.)- Hide quoted text -

- Show quoted text -

Sorry, I wasn't clear. *The As, Bs, Cs, etc for each K cell are all
different As, Bs, Cs, etc which I want to be able to input.- Hide quoted text -

- Show quoted text -

Hello John. For example:

K1 = (2 X 3) + (3 X 5.3) + (2 X 2.1) ...
K2 = (1.3 X 4.2) + (2.9 X 3.2) + (1.9 X 2.7) ...

I want to input 2, 3, 3, 5.3, 2, 2.1... somewhere and get K1
Input 1.3, 4.2, 2.9, 3.2, 1.9, 2.7... somewhere and get K2
Input ... etc

Is there some way to avoid setting up a separate group of cells for
every calculation for every K cell? Can I, for example, click on or
otherwise select K1 and input 2, 3, 3, 5.3, 2, 2.1, etc and get (2 X
3) + (3 X 5.3) + (2 X 2.1) ... to appear in K1.