SUMIF multiple columns based on criteria (both column and row)

[leathan]

I haven't been able to figure out how to SUMIF below. I have a data pull where I get amounts by months/quarters for sales regions. I want to sum up the sales for Region East for Q1 (so multiple columns of data). When I try a SUMIF it only does one column. I've seen threads about using an ARRAY formula (CSE), but I'm not sure how I combine condition for row (East) with condition for column (Q1).
[TABLE="width: 413"]
<colgroup><col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" span="7"> <tbody>[TR]
[TD="width: 78, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 78, bgcolor: transparent"]Jan[/TD]
[TD="class: xl65, width: 78, bgcolor: transparent"]Feb[/TD]
[TD="class: xl65, width: 78, bgcolor: transparent"]Mar[/TD]
[TD="class: xl65, width: 78, bgcolor: transparent"]Apr[/TD]
[TD="class: xl65, width: 78, bgcolor: transparent"]May[/TD]
[TD="class: xl65, width: 78, bgcolor: transparent"]Jun[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Region[/TD]
[TD="class: xl65, bgcolor: transparent"]Q1[/TD]
[TD="class: xl65, bgcolor: transparent"]Q1[/TD]
[TD="class: xl65, bgcolor: transparent"]Q1[/TD]
[TD="class: xl65, bgcolor: transparent"]Q2[/TD]
[TD="class: xl65, bgcolor: transparent"]Q2[/TD]
[TD="class: xl65, bgcolor: transparent"]Q2[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]East[/TD]
[TD="class: xl66, bgcolor: transparent"]9[/TD]
[TD="class: xl66, bgcolor: transparent"]8[/TD]
[TD="class: xl66, bgcolor: transparent"]5[/TD]
[TD="class: xl66, bgcolor: transparent"]9[/TD]
[TD="class: xl66, bgcolor: transparent"]7[/TD]
[TD="class: xl66, bgcolor: transparent"]6[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Central[/TD]
[TD="class: xl66, bgcolor: transparent"]8[/TD]
[TD="class: xl66, bgcolor: transparent"]4[/TD]
[TD="class: xl66, bgcolor: transparent"]8[/TD]
[TD="class: xl66, bgcolor: transparent"]3[/TD]
[TD="class: xl66, bgcolor: transparent"]3[/TD]
[TD="class: xl66, bgcolor: transparent"]10[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]West[/TD]
[TD="class: xl66, bgcolor: transparent"]7[/TD]
[TD="class: xl66, bgcolor: transparent"]2[/TD]
[TD="class: xl66, bgcolor: transparent"]9[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"]10[/TD]
[TD="class: xl66, bgcolor: transparent"]9[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]East[/TD]
[TD="class: xl66, bgcolor: transparent"]7[/TD]
[TD="class: xl66, bgcolor: transparent"]6[/TD]
[TD="class: xl66, bgcolor: transparent"]10[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"]8[/TD]
[TD="class: xl66, bgcolor: transparent"]6[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Central[/TD]
[TD="class: xl66, bgcolor: transparent"]8[/TD]
[TD="class: xl66, bgcolor: transparent"]7[/TD]
[TD="class: xl66, bgcolor: transparent"]10[/TD]
[TD="class: xl66, bgcolor: transparent"]8[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[TD="class: xl66, bgcolor: transparent"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]West[/TD]
[TD="class: xl66, bgcolor: transparent"]2[/TD]
[TD="class: xl66, bgcolor: transparent"]8[/TD]
[TD="class: xl66, bgcolor: transparent"]9[/TD]
[TD="class: xl66, bgcolor: transparent"]3[/TD]
[TD="class: xl66, bgcolor: transparent"]7[/TD]
[TD="class: xl66, bgcolor: transparent"]10[/TD]
[/TR]
</tbody>[/TABLE]

Any help would be appreciated.

Thanks.

 

[Weazel]

something like...

I2=SUMPRODUCT((A3:A8="East")*(B2:G2="Q1")*(B3:G8))

[TABLE="class: grid"]
<tbody>[TR]
[TD]Row\Col[/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[TD]

I​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Region[/TD]
[TD]Q1[/TD]
[TD]Q1[/TD]
[TD]Q1[/TD]
[TD]Q2[/TD]
[TD]Q2[/TD]
[TD]Q2[/TD]
[TD][/TD]
[TD]

45​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]East[/TD]
[TD]

9​

[/TD]
[TD]

8​

[/TD]
[TD]

5​

[/TD]
[TD]

9​

[/TD]
[TD]

7​

[/TD]
[TD]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]Central[/TD]
[TD]

8​

[/TD]
[TD]

4​

[/TD]
[TD]

8​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD]

10​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]West[/TD]
[TD]

7​

[/TD]
[TD]

2​

[/TD]
[TD]

9​

[/TD]
[TD]

1​

[/TD]
[TD]

10​

[/TD]
[TD]

9​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]East[/TD]
[TD]

7​

[/TD]
[TD]

6​

[/TD]
[TD]

10​

[/TD]
[TD]

1​

[/TD]
[TD]

8​

[/TD]
[TD]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]Central[/TD]
[TD]

8​

[/TD]
[TD]

7​

[/TD]
[TD]

10​

[/TD]
[TD]

8​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]West[/TD]
[TD]

2​

[/TD]
[TD]

8​

[/TD]
[TD]

9​

[/TD]
[TD]

3​

[/TD]
[TD]

7​

[/TD]
[TD]

10​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[leathan]

Thanks a bunch - works perfectly. Much appreciated!