Copying formulas too smart for itself...
.....or me
I have a formula and when I either copy and paste it the formula tries to be "smart" and changes the reference cels. I want to just copy and paste it with out it trying to change anything. If it makes any difference the formula is =SUMPRODUCT(--(PH3031!A3:A20=E2),--(PH3031!I3:I20="paid"),--(PH3031!G3:G20)) I've got this forumla about 100 times in a Worksheet and need to just change the E2. See when I copy and paste or drag this formula it changes all the references. A tip here would save me lots-o-headaches. Thanks, Ivano |
Use $A$3:$A$20 etc..
Inserting a $ before will remove the smartness of the formula.. To change all formulas..Select entire coloumn, press CTRL + H and you will see a replace box. There relpace A3:A20=E2 with $A$3:$A$20=$E$2 and so on... "Ivano" wrote: ....or me I have a formula and when I either copy and paste it the formula tries to be "smart" and changes the reference cels. I want to just copy and paste it with out it trying to change anything. If it makes any difference the formula is =SUMPRODUCT(--(PH3031!A3:A20=E2),--(PH3031!I3:I20="paid"),--(PH3031!G3:G20)) I've got this forumla about 100 times in a Worksheet and need to just change the E2. See when I copy and paste or drag this formula it changes all the references. A tip here would save me lots-o-headaches. Thanks, Ivano |
That worked great... THX |
All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com