Countif formula with reference to other column value

[praveen_verma]

Hello,

I have a problem in Excel using the countif formula.

I want to count all the values that are more than 0 in column C in column L

As per the below image, Col A is Date, Col B is Symbol, Col C is PIPS Count (value of col B)

In Col J, there is again Symbol and in Col K is counting of Symbol from Col B. (which is absolutely correct)

My Problem lies in Col L and Col M

In Col L, I want all values of column J from Column C which is more than 0

for example, In Column J value is EURUSD
so I need all count of EURUSD from column C which more than 0(positive) in column L and so on.

Thank you if anyone can help in this formula.

 

[Fluff]

Hi & welcome to MrExcel.

How about

=countifs(c:c,">0",b:b,j2)

 

[praveen_verma]

Thank you @Fluff
it helps me a lot. thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback.