Google Sheets Lookup & Sum

[bkg73123]

Hello,

I need help please.
I am trying to create a lookup and sum type formula for two different columns G & H.

 

[bkg73123]

I figured it out with SUMIF

 

[smozgur]

I figured it out with SUMIF

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. In fact, that would be great if you could post your SUMIF formula that helped you. Otherwise, please do not mark a post that doesn't contain a solution.

 

[bkg73123]

SOLUTION:

=IF(sumif($BE$3:$BE$72,BG3,$BC$3:$BC$72)=0,"",sumif($BE$3:$BE$72,BG3,$BC$3:$BC$72))