| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal
I have values in cells c9 to c12 and values in c15 to c18. In c19 I want the
subtotal of c9 times c15, + c10 times c16, + c11 times c17, + c12 times c18. I used the formula in c19 as follows: =subtotal(9,(c9*c15)+(c10*c16)+c11*c17)+(c12*c18)) but it is not working. Please for some help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal
One way:
=SUMPRODUCT(C9:C12,C15:C18) In article , RM wrote: I have values in cells c9 to c12 and values in c15 to c18. In c19 I want the subtotal of c9 times c15, + c10 times c16, + c11 times c17, + c12 times c18. I used the formula in c19 as follows: =subtotal(9,(c9*c15)+(c10*c16)+c11*c17)+(c12*c18)) but it is not working. Please for some help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal
Why not
=C9*C15+C10*C16+C11*C17+C12*C18 Mike "RM" wrote: I have values in cells c9 to c12 and values in c15 to c18. In c19 I want the subtotal of c9 times c15, + c10 times c16, + c11 times c17, + c12 times c18. I used the formula in c19 as follows: =subtotal(9,(c9*c15)+(c10*c16)+c11*c17)+(c12*c18)) but it is not working. Please for some help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal
thanks Mike and McG for your responses but they would not quite work because
I have more groups of subtotals to place in the worksheet and at the end I want the grand total of all the subtotals. I am using Office 2003 I don't know if itb is better able to be achieved in the 2007 version. I got it easily done in Lotus but I would have liked to use it in Excel. "Mike" wrote: Why not =C9*C15+C10*C16+C11*C17+C12*C18 Mike "RM" wrote: I have values in cells c9 to c12 and values in c15 to c18. In c19 I want the subtotal of c9 times c15, + c10 times c16, + c11 times c17, + c12 times c18. I used the formula in c19 as follows: =subtotal(9,(c9*c15)+(c10*c16)+c11*c17)+(c12*c18)) but it is not working. Please for some help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
