i am using a sum if in a formula and i want to copy and paste it down my
spread sheet. when i do excell changes all the cell references down 1 number.
the only number in the sum if formula i want to have change is the critria, i
want the range and sum range to be the same for all cells involved. i would
just type it in each cell but i am looking at 300 pluss cells that i would
have to change. is there a way to keep excell from changing all the cell
references in a formulas