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.)