# Sumif criteria

Occasional Contributor

# Sumif criteria

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

# Re: Sumif criteria

@DBreezy92 That would be in H2:

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

and copy down.

# Re: Sumif criteria

Ahh thank you, I was putting the formula backwards.