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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by Date, And SUM
If dates are formatted as DATE they should sort correctly.
To get total for a project perhaps use: =SUMIF(B:B,"=" & X1,C:C) where X1 contains project ID, Column B contains the Project IDs and column C the costs HTH "Zee" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|