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
Thank you so much for your quick response! The F4 tip works perfect and all my numbers are accurate! Thanks again!