Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have three 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)) This counts the number of positive trades =COUNTIF(Trades!H2:H2000,"<0") What I would like to do is combine the three formulas and have the formula count the number of positive trades for the stocks that have the same symbol and fall withiin the same month. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
Countif ??? | Excel Worksheet Functions | |||
Countif, Sumif, If - help! | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |