I have made a a metric to a spreadsheet and want to do the same with another one exactly like it.
When I had copied over the spreadsheet with all the countif formulas in it the formula changed and added the title of the spread sheet I had taken it from.
For example this is the original formula:
=COUNTIF(KettleCheck!C4:C121,">="&DATE(2011,1,1))-COUNTIF(KettleCheck!C4:C121,">="&DATE(2011,1,32))
This is the formula after I copied it into the next workbook:
=COUNTIF('[Production Certification Records]KettleCheck!C4:C121,">="&DATE(2011,1,1))-COUNTIF('[Production Certification Records]KettleCheck!C4:C121,">="&DATE(2011,1,32))
I want to remove the '[Production Certification Records] without having to do this by hand on each one, for there are over 500 cells with this problem.
Any advise?
Bookmarks