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
|