Copying formulas too smart for itself...

[Guest]

.....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

 

[Guest]

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...

 

[Guest]

That worked great... THX