Sumif criteria

Copper Contributor

Hi,

 

I am looking to use a sumif formula where the criteria is that a second column matches the entries in a third column. 

 

I can not figure out the formula, the attached document should give a good idea on what I am trying to do.

 

Thanks

2 Replies

@DBreezy92 That would be in H2:

=SUMIF($C$2:$C$7,G2,$B$2:$B$7)

 and copy down.

Ahh thank you, I was putting the formula backwards.