SUM a range dependent on dates

[Qaspec]

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.

 

[Luke M]

Including data with today's date:

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

 

[Bernard Liengme]

To sum the values in D column when corresponding B values are equal or less
than TODAY
=SUMIF(D130,"<="&TODAY(),B1:B30)
change D1 and B1 to D2 and B2 if row 1 had labels
best wishes

 

[Bernard Liengme]

Opps, I had the dates in D and values in B. Sorry!