| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum within date span
I have a date column (C) and another column (D) with a numerical value.
I want to get a sum of all the values in column D for all entries in the last 6 months. Any suggestions on how I can accomplish that? Jim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum within date span
Possibly
=SUMIF(C:C,""&DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),D:D) -- Regards, Tom Ogilvy wrote in message oups.com... I have a date column (C) and another column (D) with a numerical value. I want to get a sum of all the values in column D for all entries in the last 6 months. Any suggestions on how I can accomplish that? Jim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum within date span
In your reply, you stated the following:
=SUMIF(C:C,""&DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),D:D) IT WORKS PERFECTLY. There are 2 items I do NOT understand. 1) the C:C and D:D references (although I can figure it out) and 2) The use of "&" -- the ambersand. Thank you, FLKulchar "Tom Ogilvy" wrote: Possibly =SUMIF(C:C,""&DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),D:D) -- Regards, Tom Ogilvy wrote in message oups.com... I have a date column (C) and another column (D) with a numerical value. I want to get a sum of all the values in column D for all entries in the last 6 months. Any suggestions on how I can accomplish that? Jim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum within date span
see response in other thread.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "F. Lawrence Kulchar" wrote in message ... In your reply, you stated the following: =SUMIF(C:C,""&DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),D:D) IT WORKS PERFECTLY. There are 2 items I do NOT understand. 1) the C:C and D:D references (although I can figure it out) and 2) The use of "&" -- the ambersand. Thank you, FLKulchar "Tom Ogilvy" wrote: Possibly =SUMIF(C:C,""&DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),D:D) -- Regards, Tom Ogilvy wrote in message oups.com... I have a date column (C) and another column (D) with a numerical value. I want to get a sum of all the values in column D for all entries in the last 6 months. Any suggestions on how I can accomplish that? Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graph over a time span | Charts and Charting in Excel | |||
| Time Span calculations | Excel Worksheet Functions | |||
| Count and/or sum data within a date span. | Excel Worksheet Functions | |||
| Can I span a record (or row of information) over more than one row | Excel Discussion (Misc queries) | |||
| Time Span | Excel Discussion (Misc queries) | |||
Hybrid Mode
