Sumif or Sumproduct with Multiple Rows & Columns

Greetings Forum,

I am trying to add only column PA. I was trying to insert a sumproduct but i kept getting an error. I have attached a picture to show an example. I would like to be able to drag the formula down for all products.
Any help is greatly appreciated. Thank you


PA PA TX TN J1 76 KS Req PA TX TN J1 76 KS Req PA TX TN J1 76 KS Req PA TX TN J1 76 KS Req PA TX TN J1 76 KS Req
Product A 1 2 3 4 5
Product B
Product C
Product D


Excel Example.PNG

Thank you so much John. I see what i did wrong. It worked.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.