Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
That worked great... THX |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Error when copying formulas | Excel Worksheet Functions | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel | |||
Excel & Copying Formulas | Excel Worksheet Functions |