#### blackcat

##### New Member

I'm struggling to find a way to lock some parts in my SUMIFs formula while still keep one column moving alphabetically when I drag the formula to other cells for auto calculation.

Here is the example:

=SUMIFS('4Active'!B:B,'4Active'!J:J,A1)

4Active is my worksheet name. I would like to fixate the parts of '4Active'!, '4Active'!J:J and A1, so when I drag the cell the formula will only change B:B to C:C, D:D, E:E and so on.

I know there should be a solution for that but just couldn't quite Google the right answer to my question. Would hugely appreciate if anyone can help out here. Many thanks in advance.

Kay