LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ken M.
 
Posts: n/a
Default What's wrong with this formula?

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 steps...

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What wrong with VLOOKUP formula TARZAN Excel Worksheet Functions 2 January 31st 05 10:09 PM
Formula "=num.de.semana(Date,2or1)" is WRONG for 2005 MrExcel77 Excel Worksheet Functions 1 January 5th 05 07:13 PM
Formula Result Correct but value in the cell is wrong jac Excel Worksheet Functions 2 December 17th 04 08:05 PM
Paste is is copying in formula, but display is wrong. Matt Excel Discussion (Misc queries) 2 December 7th 04 08:37 PM
Paste is is copying in formula, but display is wrong. Matt Excel Worksheet Functions 2 December 7th 04 08:37 PM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"