Adding a column based on greater than a date
 

I am trying to add a column (Col. A) based on a date (Col. B). I want
to add Col. A if Col. B is within the next 30 days of today's date
(which I've put in Col. C). The formula I've tried is: SUMIF(A,"BC
AND B<=C") but it doesn't work. Any ideas about what I'm doing wrong?

=SUMPRODUCT(--(B1:B1000=TODAY()),(B1:B1000<=TODAY()+30),A1:A100 0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Toni G." wrote in message
om...
I am trying to add a column (Col. A) based on a date (Col. B). I want
to add Col. A if Col. B is within the next 30 days of today's date
(which I've put in Col. C). The formula I've tried is: SUMIF(A,"BC
AND B<=C") but it doesn't work. Any ideas about what I'm doing wrong?

for a range between 1-500

=SUMPRODUCT((B1:B500<=(TODAY())+30)*(B1:B500=TODA Y()),A1:A500)

Using entire columns error's out, and is uneeded unless you have a very
large amount of data.

As it turns out, the function is a bit more complicated by the fact
that I need to add three columns. This is for estimating cashflow and
here's what I've tried to do with what's been suggested but it's not
quite working:

=SUMPRODUCT((J4<=(TODAY())+30)*(J4=TODAY()),S4)+( (N4<=(TODAY())+30)*(N4=TODAY()),T4)+((Q4<=(TODAY( ))+30)*(Q4=TODAY()),U4)

whe
J4 - Date of deposit
S4 - Amount of deposit
N4 - Date of interim payment
T4 - Amount of interim payment
Q4 - Date of final payment
U4 - Amount of final payment

Any other suggestions?


"UBER_GEEK" wrote in message roups.com...
for a range between 1-500

=SUMPRODUCT((B1:B500<=(TODAY())+30)*(B1:B500=TODA Y()),A1:A500)

Using entire columns error's out, and is uneeded unless you have a very
large amount of data.

I think you need to explain what the rules are, your formula is just a bit
of rubbish <bgv

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Toni G." wrote in message
om...
As it turns out, the function is a bit more complicated by the fact
that I need to add three columns. This is for estimating cashflow and
here's what I've tried to do with what's been suggested but it's not
quite working:


=SUMPRODUCT((J4<=(TODAY())+30)*(J4=TODAY()),S4)+( (N4<=(TODAY())+30)*(N4=TO
DAY()),T4)+((Q4<=(TODAY())+30)*(Q4=TODAY()),U4)

whe
J4 - Date of deposit
S4 - Amount of deposit
N4 - Date of interim payment
T4 - Amount of interim payment
Q4 - Date of final payment
U4 - Amount of final payment

Any other suggestions?


"UBER_GEEK" wrote in message
roups.com...
for a range between 1-500

=SUMPRODUCT((B1:B500<=(TODAY())+30)*(B1:B500=TODA Y()),A1:A500)

Using entire columns error's out, and is uneeded unless you have a very
large amount of data.