SUM a range dependent on dates
 

I have projected volume in column D rows 1-30
I have dates in column B 1-30

I would like to only sum in cell d 31 up to today. Basically a MTD total.

SUM a range dependent on dates
 

In D31 try the below formula. Assume you have the dates in excel date format

=SUMIF(B1:B30,"<=" & TODAY(),D1:D30)

If this post helps click Yes
---------------
Jacob Skaria


"Qaspec" wrote:

I have projected volume in column D rows 1-30
I have dates in column B 1-30

I would like to only sum in cell d 31 up to today. Basically a MTD total.

SUM a range dependent on dates
 

Including data with today's date:

=SUMIF(B1:B30,"<="&TODAY(),D1:D30)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Qaspec" wrote:

I have projected volume in column D rows 1-30
I have dates in column B 1-30

I would like to only sum in cell d 31 up to today. Basically a MTD total.

SUM a range dependent on dates
 

To sum the values in D column when corresponding B values are equal or less
than TODAY
=SUMIF(D1:D30,"<="&TODAY(),B1:B30)
change D1 and B1 to D2 and B2 if row 1 had labels
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Qaspec" wrote in message
...
I have projected volume in column D rows 1-30
I have dates in column B 1-30

I would like to only sum in cell d 31 up to today. Basically a MTD total.

SUM a range dependent on dates
 

Opps, I had the dates in D and values in B. Sorry!
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Qaspec" wrote in message
...
I have projected volume in column D rows 1-30
I have dates in column B 1-30

I would like to only sum in cell d 31 up to today. Basically a MTD total.