SUM using INDEX and MATCH

[cmaino]

I am trying to sum all the matches of a cell from another sheet.

=INDEX(eBIAMT,SMALL(IF(eBIOPPS=$B2,ROW(eBIOPPS)-ROW(INDEX(eBIOPPS,1,1))+1),L2))

eBIAMT is in sheet1 and it is column B
eBIOPPS is in sheet1 and it is in column A

$B2 is an OPPid that will or will not exists in eBIOPPS and could be there multiple times

 

[Eric W]

Re: SUM using INDEX and MATCG

Welcome to the Board.

Try:

=SUMIF(eBIOPPS,$B2,eBIAMT)