This is helpful. But I'm also wondering if there is a way to do this,
assuming that C2 does NOT have the current date. isn't there a way that you
can include in the formula something like:

=sumproduct(--(a2:a1000<(NOW+30)*(b2:b1000))

....I tried that, but I don't think I have the formula right for the "now+30"
part. How else would I do that?



"Marcelo" wrote:

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.