Thread: Subtotal formulas that chooses values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Subtotal formulas that chooses values
mikeburg,
In I5 use:

=SUMPRODUCT($D$4:$H$4, D5:H5)

Then copy down.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote