hi! please help!
I want to sum up some column if, among other criterias, the follow is right:
---------if date in criteria range doesn't differ from target date by more then 7 days.
have no idea how to accomplish that.
Thanks in advance!
hi! please help!
I want to sum up some column if, among other criterias, the follow is right:
---------if date in criteria range doesn't differ from target date by more then 7 days.
have no idea how to accomplish that.
Thanks in advance!
Upload example workbook
Solution:
Where E2 is the target cell and column E contains dates.Please Login or Register to view this content.
Last edited by Alexander_Golinsky; 04-08-2013 at 03:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks