blackcat
New Member
Hi everyone,
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
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