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).
<colgroup><col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" span="7">
<tbody>
</tbody>
Any help would be appreciated.
Thanks.
Jan | Feb | Mar | Apr | May | Jun | |
Region | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 |
East | 9 | 8 | 5 | 9 | 7 | 6 |
Central | 8 | 4 | 8 | 3 | 3 | 10 |
West | 7 | 2 | 9 | 1 | 10 | 9 |
East | 7 | 6 | 10 | 1 | 8 | 6 |
Central | 8 | 7 | 10 | 8 | 1 | 1 |
West | 2 | 8 | 9 | 3 | 7 | 10 |
Any help would be appreciated.
Thanks.