Doesn't help since, new entries would be made to the database and the formula contains fixed cell references. I also made a mistake in the database. the CW colum is not filled as week number but as 2014-01 or 2015-06 or 2015-43. Some clarification, small explanation on why MMULT function works here would be great!


Quote Originally Posted by Vikas_Gautam View Post
Got the solution...
Try this..
Formula: copy to clipboard 
=MMULT(MAX((Y4:Y9=MAX(Y4:Y9))*I4:I9*($K$4:$K$9="committed")),1)

check the attachment..

Don't forget to click *
http://www.Excel-Buzz.blogspot.in