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.