Index Match with Duplicates?

Hi, I'm no expert and as such am having trouble getting to grips with the useful INDEX/MATCH combination.

I need a formula which will SUM all of the relevant values from the data table F1:N12, and put the sum value in corresponding cells D16:D29.

I've manually entered what the results for the desired formula would be in the top half of the results table A1:D29.

The formula needs to find the ITEM, and SUM all of the VALUES present for that ITEM on the relevant WEEK and DAY.

Hope this is clear and one of you experts can help!

Thanks
Larchfield

Try

=SUMPRODUCT(($H$3:$N$12)*($F$3:$F$12=$A2)*($H$2:$N$2=$B2)*($G$3:$G$12=$C2))

Copy down

Thank you MarvinP and JohnTopley, both your responses lead to the correct results I was looking for.
I'm OK with pivot tables and they're great for summarising, but I needed a formula option for continuous adding to rows and rows of data. A formula is much more suitable to my needs.
Cheers

=SUMPRODUCT(($H$3:$N$12)*($F$3:$F$12=A16)*($G$3:$G$12=C16)*($H$2:$N$2=B16))

put that in D16

drop down.

Interesting question. Thanks for asking

posted as it is a slight variation of the above