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.

=SUMPRODUCT(--(Trades!C2:C2000=Performance!A15),--(MID(Trades!A2:A2000,1,3)=
E1),--(Trades!H2:H2000))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jnorton" wrote in message
...
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.

one way:

=SUMPRODUCT(--(MID(Trades!A2:A2000,1,3)=E1),
--(Trades!C2:C2000=Performance!A15), Trades!H2:H2000)

For an explanation of "--" see

http://www.mcgimpsey.com/excel/doubleneg.html




In article ,
"jnorton" wrote:

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.