LinkBack URL
About LinkBacks
Perhaps something like..
=SUMIF(B:B,C2,A:A)
EDIT: Apologize. You said after the reminder dates...
=SUMIF(B:B;">"&C2;A:A)
Perhaps something like..
=SUMIF(B:B,C2,A:A)
EDIT: Apologize. You said after the reminder dates...
=SUMIF(B:B;">"&C2;A:A)
Last edited by Fotis1991; 09-29-2013 at 02:35 PM. Reason: Edit
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.
Hi,
I messed up here with the question, sorry all. I realise now the question makes no sense at all.
The criteria for the SUM part of the formula is not whether the actual payment due dates fall after the reminder dates but instead whether TODAY() is greater than the reminder dates set for each row.
This is why I thought this may be an array formula as each row needs to be checked against todays date and the reminder date and then sum those rows where Today() >= reminder date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks