LinkBack URL
About LinkBacks
In Cell E10, I want to SUM Cells D5:D9 only If the corresponding date in Cells E5:E9 is today or in the future.
Please let me know if more information/explanation is needed.
Thanks!
In Cell E10, I want to SUM Cells D5:D9 only If the corresponding date in Cells E5:E9 is today or in the future.
Please let me know if more information/explanation is needed.
Thanks!
Last edited by ExelDummy; 01-30-2014 at 07:48 PM. Reason: Title
=sumif(e2:e9,">="&today(),$d$2:$d$9)
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Welcome to the forum.
We'd like to help you but first..
Pls take some minutes to read forum rules and specially-in this case- rule#1 and change your title
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Robert, your formula worked like a charm!
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks