Sum Product using Sum if command

[kate.middleton1]

Hello everybody,

I need help regarding sumproduct using sum if statement. For the sake of example workbook is attached with this post.

[Spencer101]

Try this is F7 and copy down for one way of doing it.
=SUMIF(L$7:L$17,E7,N$7:N$17)+SUMIF(L$7:L$17,E7,M$7:M$17)

Your example value is L7 is incorrect.

[Spencer101]

Or this in F7 and copied down for another way.
=SUMPRODUCT((L7:L17=E7)*(M7:N17))