G
Guest
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)*(Trades!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.
This sums the product of all my trades on another worksheet that have the
same symbol.
=SUMPRODUCT((Trades!C2:C2000=Performance!A15)*(Trades!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.