LinkBack URL
About LinkBacks
worksheet name : top 3
Cell B2 formula , Drag down
Formula:
=SUMPRODUCT(SUMIFS(projections!$C:$C,projections!$B:$B,$A2,projections!$C:$C,">="&LARGE((projections!$B$2:$B$92=$A2)*(projections!$C$2:$C$92),3)))
worksheet name : top 3
Cell B2 formula , Drag down
Formula:=SUMPRODUCT(SUMIFS(projections!$C:$C,projections!$B:$B,$A2,projections!$C:$C,">="&LARGE((projections!$B$2:$B$92=$A2)*(projections!$C$2:$C$92),3)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks