This is my combo of Bob and Aladin. Yet still not working. Where is my error?

=SUMIF(--(J2:J250=TODAY()+29)&I2:I250<=.01)

Walking through this in baby step...

In cell T3 I am asking Excel to... Sum if J2-J250 is Today or plus the next
29 days and I20-I250 has a dollar amount greater than or equal to a penny.

Is that not what I am doing? REALLY STUCK GUYS! Thanks for the continued help.

Ken


"Bob Phillips" wrote:

=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?