Forum Discussion
Range issue when I drag and copy SUMIF
- Oct 29, 2018
When you select the range then for the lets say F1:F200 press F4 key in your keyboard so that it makes is absolute reference and it will look like this
$F$1:$F$200 you can also manually put the dollar signs, but pressing F4 will do it for you easily.
You have not attached the data, but from what I can guess, you need to use the absolute reference in your range and mixed reference cell for the cell of criteriaSo your formula should be something like this
=SUMIF($F$1:$F$200,$K20,$G$1:$G$200)
a dollar sign in front of Column $A1 means column will not move but row will move
A$1 means row will not move but column will move
$A$1 means both column and row will not move.
A1 means both column and row will move
When you select the range then for the lets say F1:F200 press F4 key in your keyboard so that it makes is absolute reference and it will look like this
$F$1:$F$200 you can also manually put the dollar signs, but pressing F4 will do it for you easily.
You have not attached the data, but from what I can guess, you need to use the absolute reference in your range and mixed reference cell for the cell of criteria
So your formula should be something like this
=SUMIF($F$1:$F$200,$K20,$G$1:$G$200)
a dollar sign in front of Column $A1 means column will not move but row will move
A$1 means row will not move but column will move
$A$1 means both column and row will not move.
A1 means both column and row will move
- Kim McraeOct 29, 2018Copper Contributor
Thank you so much for your quick response! The F4 tip works perfect and all my numbers are accurate! Thanks again!