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.