Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
=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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
+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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help (new to Spreadsheet) | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
How to use same formula throughout the spreadsheet?? | New Users to Excel | |||
I want to update the formula in a spreadsheet from 04 to 05. Is . | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |