SUM if date < 30 days away
 

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.

SUM if date < 30 days away
 

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.

SUM if date < 30 days away
 

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.

SUM if date < 30 days away
 

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.

SUM if date < 30 days away
 

=SUMPRODUCT(--(A2:A200TODAY()),--(A2:A200<TODAY()+30),B2:B200)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Meesheltx" wrote in message
...
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.

SUM if date < 30 days away
 

That is perfect...thank you!!

"Dave O" wrote:

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.

SUM if date < 30 days away
 

=sumproduct(--(a2:a1000today()),--(A2:A1000<today()+30),B2:B1000)

hth
regards from Brazil
Marcelo


"Meesheltx" escreveu:

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.