View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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