Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003
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.) |
Multiple calculations within cell? Writing in Excel 2000, using i
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.) |
Multiple calculations within cell? Writing in Excel 2000, using i
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.) |
Multiple calculations within cell? Writing in Excel 2000, using i
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. |
Multiple calculations within cell? Writing in Excel 2000, usin
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. |
Multiple calculations within cell? Writing in Excel 2000, usin
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. |
Multiple calculations within cell? Writing in Excel 2000, usin
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. |
All times are GMT +1. The time now is 10:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com