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.