| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum if Date is?
Perfect Thanks.
"Bob Phillips" wrote: If you want that, try =SUMPRODUCT(--(YEAR($A$1:$A$365)=YEAR(TODAY())),--(MONTH($A$1:$A$365)=1)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jman" wrote in message ... Yes,, Just what i wanted. I have a question regarding. the "2008" in your formula.. Whe my dates change to 2009. will your formula still read it? or. Do i need to do (Ctrl H) and update the formula myself. "Bob Phillips" wrote: Do you mean =SUMPRODUCT(--(YEAR($A$1:$A$365)=2008),--(MONTH($A$1:$A$365)=1)) for January totals etc. =SUMPRODUCT(--(YEAR($A$1:$A$365)=2008),--(MONTH($A$1:$A$365)=1),B$1:B$365) for 60 min etc. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jman" wrote in message ... Sum if Month is "01-01-08" , same with february and so on. Column A1 to A365 i have dates for the whole year..The dates are not static will automatically update at end of year. These are the Table names for columns are (B:1 "60min), (D:1 "90min") , (F:1 "120min"), (H:1 "75min") , (J:1"15min") , (L:1 "30 min") , (N: "50min)". and the table runs down to row 365 i have numbers that are automatically transfered per correct Date in these columns "1" meaning one client "3" meaning three clients.. in corseponding time columns. I want a formula that will look at the date in and add the corresponging total for each column "60 min" 90min" 120min, 75 min, 15min, 30min, 50min. Per correct month. January totals thru December totals will be put in a different table . In R:1 thru R12 i will have only names January -December. In S1: S12 I need totals only for "60min" , In T1 to T12 for 90min, and so on to X |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Threaded Mode
