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

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

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

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.

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.

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.

If you want those values to calculate in the K cells to be only 1 value, you
can actually type in K1 for example:
=(2*3)+(3*5.3)+(2*2.1)

But if you want 6 separate values that are not predefined as above, and you
want to be able to choose those 'values' on the fly, then you have to have a
place (i.e.: cells A through F in each corresponding row) to put the values
in.

--
John C


"robzrob" wrote:

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.