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