Sum within date span

  • Thread starter Thread starter jsollows
  • Start date Start date
J

jsollows

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
 
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
 
see response in other thread.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM - IF - AND 7
Sum for last calendar month & year 7
Sum for last 90 days 3
Sum work hours to hours & nearest 10th of an hour 14
Couple subs need help with 2
Multiple SUM's in a column 15
Find a value in a sheet and replace it with another value if it matches 8
use month in cell date to sum all relevant cells 2

Back
Top