Add an S to the Countif statement to make it multiple conditions. Personally if and when I use Sumif or Countif... it is Sumifs or Countifs, really no need to limit yourself so make it a habit to use those.

Now that is really a side note since you are looking through 2 different ranges for that value. That is, if I read what you put right. The answer is in your question!
I would like it to only be applied if the exact value appears on sheet 2,colum b, and If there is a value next to it on sheet 2 column c.
Use an AND statement telling it to find a value is just to say that the cell value in that range is >0 in a count if you wrap up your mathematical qualifiers with quotes and throw an & symbol to join the criteria, so ">"&0

=AND(Countifs(sheet2!b1:b10,sheet1!b6)>0,Countifs(sheet2!C1:C10,">"&0)>0)

That should do it...