Easy Sort Question

[dkgolfer39]

I'm trying to sort the following example:

A1: =(B5+B6)
A2: =(B14+B16)
A3: =(B2+B18)

Cells A1 - A3 yield values of 5,3,10. I would like to sort smallest to largest. When I highlight the cells and use the sort button, it gets all messed up. What am I missing?

Thanks for the help!

[dkgolfer39]

Nevermind. Got it. Sorry.

[TYork]

You need to use absolute values because when you sort it changes the cell references. so, use:

a1: = ($b$5 + $b$6) etc.

and then sort.