I have a fairly large spreadsheet that involves adding and deleting rows
based on bills paid to date. I am using a "sumif" stipulation on the
worksheet to add everything from this one vendor in this one department. I
would like to be able to add rows on the bottom, then sort the data. The
problem I'm having is that when I do this, the formulas get all mixed up.
For example is refering to a1:a5 before I sort. I add a line at the bottom
that pushes the first row down. The formula now refers to a2:a6. I would
like that formula to refer to a1:a6.