Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding cells then sorting
Hi
I need to add specific cells in a column, from one worksheet into another, by department. The easiest way I have found to do this is to sort the sheet by department then add the cells for each department, but I need to resort the sheet by surname. example: sheet2!B9 =sheet1!F11+sheet1!F12+sheet1!F13+sheet1!F14+sheet 1!F15 the only problem is when I resort sheet1 by surname the cells added in sheet2 remain the same (as above), when I want the cells added to also be resorted (as below). example: sheet2!B9 =sheet1!F15+sheet1!F9+sheet1!F26+sheet1!F12+sheet1 !F5 I hope this makes sense, I have tried using relative, absolute and mixed references but nothing works. Please help Helen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding cells then sorting
Helen B wrote:
Hi I need to add specific cells in a column, from one worksheet into another, by department. The easiest way I have found to do this is to sort the sheet by department then add the cells for each department, but I need to resort the sheet by surname. example: sheet2!B9 =sheet1!F11+sheet1!F12+sheet1!F13+sheet1!F14+sheet 1!F15 the only problem is when I resort sheet1 by surname the cells added in sheet2 remain the same (as above), when I want the cells added to also be resorted (as below). example: sheet2!B9 =sheet1!F15+sheet1!F9+sheet1!F26+sheet1!F12+sheet1 !F5 I hope this makes sense, I have tried using relative, absolute and mixed references but nothing works. Please help Helen Instead of (re)sorting, try using Autofilter. In Excel 2003 this is found under Data | Filter | Autofilter. Or, use sorting, but after finding the values with formulas, copy the results and Edit | Paste Special | Values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting and adding totals | Excel Worksheet Functions | |||
sorting or adding numbers of the same value | Excel Discussion (Misc queries) | |||
sorting and adding cells in different work sheet? (hard stuff) | Excel Discussion (Misc queries) | |||
Sorting and Adding Space | Excel Worksheet Functions | |||
Sorting and adding | Excel Discussion (Misc queries) |