Formula Help (new to Spreadsheet)

[Ken Moskowitz]

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?

 

[Bob Phillips]

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

--

HTH

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

 

[Aladin Akyurek]

=SUMIF(DateRange,">="&T3,SumRange)

 

[Ken M.]

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]

+SUMPRODUCT(--(J2:J50>=TODAY()+29),--(I2:I50>=.01),I2:I50)

--

HTH

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