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. |
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 |