Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet formula incorrect after copying to another worksheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formula into another worksheet | Excel Worksheet Functions | |||
Copying a formula from one worksheet to another worksheet | Excel Worksheet Functions | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
Same formula referencing same cells returns incorrect results, randomly, when pasted into new worksheet | Excel Worksheet Functions | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions |