Index/Match with ability to sum one of the matches?

[Revitigs]

Hello,

I have a data set that are weeks as the columns and types of sales as the rows, filling the cells with sales counts.
There are multiple sales types on the rows that need to be summed together. The index/match formula works great except it only grabs the first of the sales type. Is there a way to grab the week column only but sum the sales count by sales type?

For example:
12/30/13 1/6/14 1/13/14 1/20/14 1/27/14 2/3/14
Service 1 1 4 1 2
Service 55 44 55 88 66 44
Product 264 206 224 244 319 324
Product 1,014 951 938 1,182 1,009 904
Referral 1,543 1,323 1,309 1,335 1,354 1,469

Thanks!!

[BadlySpelledBuoy]

You could use SUMPRODUCT. See attached for example.

[ragulduy]

Hi, maybe an array formula (confirm with ctrl+shift+enter) like:
=SUM(IF(A2:A16=H3,OFFSET(A2:A16,0,MATCH(I3,B1:E1,0)),0))
take a look at the attachment for an example.

[Revitigs]

Thank you both a million!
The sumproduct seems like it will perfectly match my needs as I will need to continuously copy this formula down across rows.

I really appreciate the quick responses!

[BadlySpelledBuoy]

Happy to help.