Sumif criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-2202675%22%20slang%3D%22en-US%22%3ESumif%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2202675%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20use%20a%20sumif%20formula%20where%20the%20criteria%20is%20that%20a%20second%20column%20matches%20the%20entries%20in%20a%20third%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20not%20figure%20out%20the%20formula%2C%20the%20attached%20document%20should%20gi%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2202675%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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.