Sum If based on selection

[cunningAce]

Hi,

I am looking for a formula that takes the Week Number, and sums anything in the relevant column but also based on the code as in the below example.

So here I would want the total for all codes 'A1' in week '201809'?

Code	201807	201808	201809	201810		Week >	201809
A1	10	15	20	25		A1	65
A1	11	16	21	26		B1	22
B1	12	17	22	27
C1	13	18	23	28
A1	14	19	24	29

<colgroup><col width="64" style="width:48pt" span="8"> </colgroup><tbody>
</tbody>

Thanks in advance.

 

[Weazel]

something like...

Unknown

	A	B	C	D	E	F	G	H
1	Code	201807	201808	201809	201810		Week >	201809
2	A1	10	15	20	25		A1	65
3	A1	11	16	21	26		B1	22
4	B1	12	17	22	27
5	C1	13	18	23	28
6	A1	14	19	24	29

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula H2 =SUMPRODUCT(($B$2:$E$6),($B$1:$E$1=$H$1)*($A$2:$A$6=G2)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[cunningAce]

Works perfect thanks

 

[Weazel]

you're welcome