I've created a spreadsheet with a dozen colums and about 150 rows.
in the 1st row cells I have a conditional formula which states Sumif "cell
Range", "Salesman Name", "Copycell Range".

I'm trying to copy and paste the whole column in the hopes I retain the same
cell ranges and formula, but evertime I paste from column A to Column B the
whole range shifts the column range.

My question is this;

Is there a way to keep the conditions in the formula from changing?

Please help.