Thread: SumProduct
View Single Post
  #1   Report Post  
jnorton
 
Posts: n/a
Default SumProduct

I have two formulas that work great by themselves

This sums the product of all my trades on another worksheet that have the
same symbol.

=SUMPRODUCT((Trades!C2:C2000=Performance!A15)*(Tra des!H2:H2000))

This sums the product of all my trades on another worksheet that have fall
in the same month.

=SUMPRODUCT((MID(Trades!A2:A2000,1,3)=E1)*(Trades! H2:H2000))

What I would like to do is combine the two and have the formula sum the
products that have the same symbol and fall withiin the same month.