Formula Help (new to Spreadsheet)
 

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?

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

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

Ken Moskowitz wrote:
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?

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?

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

--

HTH

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


"Ken M." wrote in message
...
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?