Forcing a sum formula...

L

LBDuperon

Please Help...

I have a spreadsheet I am using for inventory numbers and costs. I
have several worksheets that link to this the inventory sheet. I know
when I link to a cell and put "$" in front of the cell, it will make
the formula fixed on the inventory sheet. My problem happened when I
added new rows and sorted my data. None of the cells that I had put
the "$" in front of the cell followed the data to the new cell after
sorting.

How can I fix my formulas so I will be able to sort and have the
formulas stay fixed?

Thanks so much,
LB
 
L

Lewis Clark

The "$" changes the relative reference to an absolute reference. It must be
applied to the row and the column separately. Try putting it in like this:
$A$1 The formula will always refer to A1 no matter where you copy it to.

If you do $A1, Column A will be fixed but the row will vary as you copy the
formula.
If you do A$1, Row 1 will be fixed but the column will vary as you copy the
formula.

Does this help?
 
L

LBDuperon

Now why didn't I know that????

Yes, you have been a huge help.

Thank much,
LB
 
L

LBDuperon

Thank you so much Lewis. I did a quick test of this in a sample sheet
yesterday and it worked perfectly. This morning I converted all my
formulas to reflect this format: =Sum('Part Data Entry'!$K$250)

When I sort my table now by column K, it seems it is not really an
absolute reference.

What am I doing wrong?

~LB
 
L

LBDuperon

I am still looking for help on this problem...anyone?

Why doesn't my absolute relationship remain "absolute" when I sort the
rows but it does remain absolute when a new row is just "inserted"
instead.


~LB
 
Top