Try
Formula:
=SUMIFS(I12:I25,L12:L25,C11,M12:M25,C7,H12:H25,INDEX(H12:H25,MATCH(C9,H12:H25,-1),1))
Try
Formula:
=SUMIFS(I12:I25,L12:L25,C11,M12:M25,C7,H12:H25,INDEX(H12:H25,MATCH(C9,H12:H25,-1),1))
Last edited by boopathiraja; 08-21-2014 at 03:17 PM.
☚ Click ★ just below left if it helps, Boo?ath?![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks