Sounds like a job for SUMPRODUCT to me. In it's simplest form having the
data set us as
A B
C D
E F
is straightforward, but I believe it allows different configurations.

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