Suddenly I have a problem with copying formulas:
I started with the following formula: =COUNTIF($D2:$D5694,D5724)
I then copied it to the next line: =COUNTIF($D3:$D5695,D5725)
That's not supposed to happen if you use the $ sign. So I checked Tools > Options > calculation. That is set to automatic. What else could cause my problem?
Last edited by StillLearning2; 02-10-2009 at 02:07 PM.
You have the $ before the column but not before the rows. If you want it anchored with both column and rowMake sense?
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I just caught it. Thanks. If I had brains...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks