Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum with Date Span
In your reply, you stated the following: (for adding numbers within the last
6 months in columns C and D: =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. PLEASE EXPLAIN?? Thank you, FLKulchar |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum with Date Span
C:C means that the whole of column C is being checked for a matching date,
and where matching the values in column D are being summed. The & is used to concatenate the operator with the calculated date so that SUMIF will check for values greater than that. -- 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: (for adding numbers within the last 6 months in columns C and D: =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. PLEASE EXPLAIN?? Thank you, FLKulchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Span calculations | Excel Worksheet Functions | |||
Count and/or sum data within a date span. | Excel Worksheet Functions | |||
claculating time span | Excel Worksheet Functions | |||
Sum within date span | Excel Programming | |||
Time Span | Excel Discussion (Misc queries) |