rs_revolution
New member
For example,
I'm referencing three cells by adding them up some values. =sum(b2:b4)
But if I happen to sort the values in column b, the sum of these values changes.
How I prevent this from happening? Where the cell sums up those specific numbers regardless if I sort my values in what ever order I wish.
Hope that was clear.
I'm referencing three cells by adding them up some values. =sum(b2:b4)
But if I happen to sort the values in column b, the sum of these values changes.
How I prevent this from happening? Where the cell sums up those specific numbers regardless if I sort my values in what ever order I wish.
Hope that was clear.