Dear All ,
Could you please help me on attached sheet
Aging Problem.xlsx
Dear All ,
Could you please help me on attached sheet
Aging Problem.xlsx
Try Perhaps
G8=D7-(SUM(IF($L$7:$L$23=C7,IF($K$7:$K$23<=E7,IF($K$7:$K$23>B7,$M$7:$M$23)))))+SUM(IF($C$7:$C$23=C7,IF($G$7:$G$23<0,$G$7:$G$23))) with CTRL+SHIFT+ENTER and drag down
Last edited by shukla.ankur281190; 04-02-2016 at 05:50 AM. Reason: missing text
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks