I ginned up some dummy data and got the results you're looking for with
this formula:
=SUMPRODUCT($A$1:$A$6,--($B$1:$B$6<TODAY()+30))

Column A contains the figures, column B contains the dates- you'll need
to provide the appropriate ranges.