Copy a Formula to Multiple Rows, but Keep One Column Ref in the Formula the Same?

AmandaMerrigan

Hey all!

I understand that when you copy a formula with criteria in certain columns to adjacent columns, it changes the column references to keep the relationship between columns the same (ie, column 10 has a formula that references col 1 & col 3, and copying the formula from col 10 to col 11 would result in the col 11 formula referencing col 2 & col 4)

Is there a way to keep a column reference as a hard reference no matter where it's place?

ie - Column 10 =Col1@row + Col3@row, Column 11 =Col2@row + Col3@row...where Col3@row reference never changes

Is there a symbol that can be put in front of it to always keep it there?

Thanks!

AmandaMerrigan

Looks like I just needed to reference the help center! I looked here but missed this one. For anyone else looking, just add a "$" to keep the column reference an absolute value.

AmandaMerrigan

Looks like I just needed to reference the help center! I looked here but missed this one. For anyone else looking, just add a "$" to keep the column reference an absolute value.