Search results

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...