Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiplying rows and passing formula throughout the col range
Is this confusing?
My formula: sum(C6*D6) to multiply price (C) vs usage (D). I need to continue multiplying like this to get a final total to get the amount spent for last year. my example: R Col C D 6 .47 3400 8 .54 1800 9 1.78 300 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiplying rows and passing formula throughout the col range
In other words, you want a single formula to calculate the grand total?
Try this: =SUMPRODUCT(C6:C9,D6:D9) -- Biff Microsoft Excel MVP "Sistereinstein" wrote in message ... Is this confusing? My formula: sum(C6*D6) to multiply price (C) vs usage (D). I need to continue multiplying like this to get a final total to get the amount spent for last year. my example: R Col C D 6 .47 3400 8 .54 1800 9 1.78 300 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiplying rows and passing formula throughout the col range
I think we are on the right track. For whatever reason, I keep on getting
$2570.00 as a total, which is the total for the first two, and the correct total should be $3104.00. I checked the formats and the $ amt is set to number w/ 2 decimal pts and the usage is number w/0 decimal pts, all down the rows. I also moved the range past those cells to see if the amount changed, and it didn't. Is this a bug? Doesn't seems it should be... "T. Valko" wrote: In other words, you want a single formula to calculate the grand total? Try this: =SUMPRODUCT(C6:C9,D6:D9) -- Biff Microsoft Excel MVP "Sistereinstein" wrote in message ... Is this confusing? My formula: sum(C6*D6) to multiply price (C) vs usage (D). I need to continue multiplying like this to get a final total to get the amount spent for last year. my example: R Col C D 6 .47 3400 8 .54 1800 9 1.78 300 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiplying rows and passing formula throughout the col range
Bug? You must have invisible characters (spaces/html characters etc) in one
or both of the last 2 cells making it text. It doesn't matter if you check the formats, if I format a cell as a currency and type in abc it will not change the format but it will be text even if the format says currency. Select the cells and type in 1.78 and 300 manually and it should work. -- Regards, Peo Sjoblom "Sistereinstein" wrote in message ... I think we are on the right track. For whatever reason, I keep on getting $2570.00 as a total, which is the total for the first two, and the correct total should be $3104.00. I checked the formats and the $ amt is set to number w/ 2 decimal pts and the usage is number w/0 decimal pts, all down the rows. I also moved the range past those cells to see if the amount changed, and it didn't. Is this a bug? Doesn't seems it should be... "T. Valko" wrote: In other words, you want a single formula to calculate the grand total? Try this: =SUMPRODUCT(C6:C9,D6:D9) -- Biff Microsoft Excel MVP "Sistereinstein" wrote in message ... Is this confusing? My formula: sum(C6*D6) to multiply price (C) vs usage (D). I need to continue multiplying like this to get a final total to get the amount spent for last year. my example: R Col C D 6 .47 3400 8 .54 1800 9 1.78 300 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Passing a range to a user defined function | Excel Discussion (Misc queries) | |||
Multiplying A Range | Excel Worksheet Functions | |||
Multiplying two rows together | Excel Worksheet Functions | |||
Passing Excel NAMED Range to VBA | Excel Worksheet Functions |