Countif

J

jnorton

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)*(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))

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

Bob Phillips

You have already posted this, and JE and I gave you an answer.

--

HTH

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

Bob Phillips

Noticed you just extended from the previous post

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

--

HTH

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

Bernie Deitrick

jnorton,

Try (all on one line - this may wrap)


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

Though why your positive trades are less than zero rather than greater than
zero.....

HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

Duh. Ignore my first post - I missed the "I want to count" part.

Try

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

HTH,
Bernie
MS Excel MVP
 
Top