Hi,
I am using excel 2007.
I am trying to copy a row of formulas and paste them exactly into other rows.
When I try this the formula is moved down by the number of rows below the
original.
Any ideas of how to paste the formulas exactly so that they look in the same
columns as the original.

The formula I am using
is:=SUMPRODUCT(--(B7:B174=B179),--(E7:E174<""))/D179*100

I only want the B179 & D 179 in the formula to change to reflect the row,
but the rest to stay the same. Hope this makes sense.


Thanks in advance
Jason Alcorn