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.