vba COUNTIF Problem

i'm using excel 2003 and i know excel 2007 can use countifs on the multiple condition.
but i only want to use countif on my vba.

Could anyone see what happen?
My logic is sheet1(no) = sheet2(no) & sheet1(amount) <> sheet2(amount) then copy sheet2 info into sheet 3

Please Login or Register  to view this content.