| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting the cells of a formula causes the formula to not work
I have a list of parts (about 50) in colomn A and thier cost in column B.
Below this data set I have a formula to sum the purchased parts, another formula to sum the welded parts, and another formula to sum the labor intensive parts. An example of these formulas would be "=sum(B2,B12,B15,B20,B35)". When I sort the list of parts alphabeticaly or the cost low to high / high to low the formulas below do not track the sorted cells. It still references the same thing (ie. "=sum(B2,B12,B15,B20,B35)") even though the sorted cells have moved positions. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Won't Work after 10 Cells | Excel Discussion (Misc queries) | |||
| Formula for sorting a range of cells in decending order | Excel Discussion (Misc queries) | |||
| Sorting and Eliminating Blank Cells in Formula range | Excel Worksheet Functions | |||
| How can I get a formula to work on visible cells with autofilter? | Excel Discussion (Misc queries) | |||
| in excel, formula to work only when all cells full of data | New Users to Excel | |||
Threaded Mode
