Sorting with formulas

C

Crowraine

I have 3 sheets. Here is the formula.
=SUM(InventoryOrdered!D23:CA23)-COUNTIF(InventorySold!B:B,"10-414500")
This is on sheet InventoryInStock

When I add another object I want to be able to sort them AtoZ and then for
the cell ex:D23:CA23 to change appropriately. When I add an object I add it
to InventoryOrdered and InventoryInStock that way the sheets are the same.
What do I do? Also, I need laymans terms and step by step instructions. I
have had no "training" in Excel and figuring this out as I go. Thank you
ahead of time for your help.

God Bless,
Harley
 
C

Crowraine

When I use the sort function it does put the list AtoZ but the formulas won't
change to the correct cell it refers to.. what do I do?
 
C

Crowraine

Nope, that doesn't work. That is referring to static numbers which would not
change. With inventory coming in and out, the number keep changing. Refering
to something just for the product info won't work. But thank you for your
nice help.

God Bless,
Harley
 
C

Crowraine

Just wanted to bump the thread up. Still having issues with sorting. Anyone
else have any what I need to do with Excel sorting?
 
C

Crowraine

Just wanted to bump the thread up. Still having issues with sorting. Anyone
else have any what I need to do with Excel sorting?

God Bless,
Harley
 
Top