Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when I data sort my formulas change
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
When I change my data, my formulas don't update the answers,why? | Excel Discussion (Misc queries) |