Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by Date, And SUM
I am in process of making an excel file for my costs.
The file contains: Date, Project, costs, discription. All of these are in a "List" so for example i could look for only a certain project. My question is: 1. How do i sort by date on the list. My date format is set to "Day-Month-Year". But when i sort by date it only looks at the first numbers which is the day, therefore not conidering month or year! 2. Under the costs colum, i have added a total costs (formula =SUM(D5:D15)). This works fine until i use list to view only one projct. At this point the cell will show the same value and if i want to get the total of one project i have to do the formula again. Is there a way so this cell will always show the SUM of the cell above it? Thanks in advance |