Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |