excel - I can't find out how to make my function work (CountIF with 2 statemants & 2 ranges) -

i can't find out how make function work. here function try make work:

=count(if(sheet1!$v$6:$v$1026;sheet2!c7, if(sheet1!$j$6:$j$1026;sheet2!b7))) 

this want do: (example)

sheet 1

    j         v         6  test      low 

sheet 2

      b      c           cell function 7    test   low                  1 

what wrong? there other way same thing?

additional question, when don't want use 1026 final range when want use range till last cell whit value, how do that?

i think trying achieve this:

=sum(if(sheet1!$v$6:$v$1026=c7,if(sheet1!$j$6:$j$1026=b7,1,0),0)) 

this array function must use crtl+shift+enter instead of enter work.

one of main problems formula if statements comprised of 3 pararmeters: test followed true , false separated comma. in formula have no tests , using semi-colon.