James wrote:
So I have tried this a few ways but with no success, I am not sure if a
formula can do what I am asking for but here is my example.

Take a good look at http://xldynamic.com/source/xld.SUMPRODUCT.html for
how to do multiple condition matches. Post back if you get stuck.