Attached sample file: Function in E2 needs to lookup/index/search through column E for a cell where a dollar amount exists....
If there's a dollar amt in E,
THEN, look adjacent to Col D and verify whether or not this date is equal to TODAY or prior to TODAY
IF true, THEN include into SUM
If the date in Col D has not yet occurred, then do not include into SUM
Bookmarks