Sumifs with multiple criteria

[rashid67]

I have created the following array formula which works fine to sum based on the multiple GL accounts. Now i want to add another criteria in to the formula to only sum based on months. My data is in a list from and it is for 12 months. The idea is that formula will look at the header for month and then only sum relevant dollars in to the column.
Col H = dollars, Col D = GL account, Col A = Month
=SUM(SUMIFS('GL Data'!$H:$H,'GL Data'!$D:$D,{"400000","400550","430260","400500","403000","403010","403505","404500"}))
Please help. Rashid

 

[AhoyNC]

Try:

Excel Workbook
	A	B	C	D	G	H
1	Month			GL		Dollars
2	Jan			400000		304
3	Jan			404500		252
4	Feb			403505		312
5	Feb			30		412
6	Feb			404500		377
7	March			404501		239
8	March			400000		201
9
10
11	Month	Feb		689
Sheet