Thread: Subtotal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RM RM is offline
external usenet poster
 
Posts: 23
Default 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.