=SUMPRODUCT(--(A1:A1000=TODAY()+29),B1:B1000)

--

HTH

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


"Ken Moskowitz" <Ken wrote in message
...
The problem is I need a DOLLAR figure for money due in 30 days (T3) (a
dynamic field) that is calculated off of balance due (I2) that have a
balance
due date (J2) of today+29 days or within 30 days. I supplied the field
names.

Any suggestions or help?