As the subject suggests, I want to be able to have formulas keep pulling data from the same source, even if I sort the source data. Forgive me if this sounds amateurish. I'm not very knowledgeable with the formula functions.

For example, say that I have data in the first four cells of column A. A1 contains the digit 3, A2, 5, A3, 1, and A4, 2. In B1, I have =SUM(A1+A2), which is 8, and B2 contains =SUM(A3+A4), which equals 3. Say that I want to sort column A, though, from lowest to highest value. Now, it reads 1, 2, 3, and 5. The formulas, however, do no adapt to this change. I would like them to still equal 8 and 3, as they did before the sort, but now, they read 3 and 8. How do I make sure that formulas still present the same values before and after I sort their source cells?