Countif

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

 

[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)

 

[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)

 

[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

 

[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

 

[Bob Phillips]

Seems neither of us bother to read it all

Bob

 

[Bernie Deitrick]

Oh, I read it - it just didn't sink in ;-)

Bernie