Hi,

=sumproduct(--(a2:a1000<c2)*(b2:b1000))

assuming the column A has the dates, column B has the amounts and C2 has the
current date.

hth
regards from Bazil
Marcelo


"Meesheltx" escreveu:

I have two columns, one with the amount due, and one with due dates. The due
dates are changing periodically, and I want my sum to only include amounts
that are due within 30 days from the current date.