--In edit mode F2, paste the formula to a cell and instead of just Enter
press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar'
you can notice the curly braces at both ends like "{=<formula}"

--You can use the below alternative (enter normally)

=SUMPRODUCT((TEXT(Sheet1!$B$2:$B$180,"mmyy")="0109 ")*
(Sheet1!$N$2:$N$180=1))


If this post helps click Yes
---------------
Jacob Skaria


"Karen" wrote:

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