I have a formula in one workbook :

=COUNT(IF((Sheet1!$B$2:$B$180=DATEVALUE("Jan-09"))*(Sheet1!$N$2:$N$180=1),Sheet1!$A$2:$A$180) )

When i copied this formula into another workbook, the answer becomes "1".
The answer in the original worksheet is "19".

How can I get this corrected? Thanks