SUMIFS with INDEX MATCH at a loss

[DEHA11]

I have a worksheet called "Summary" that should show the total sales by month by category. On a separate worksheet, called "2019", I have a list of sales. I am trying to update the "Summary" worksheet to show the sum of all of sales for each category for each month.

The formula I have at this time is returning 0. This indicated cell should return 5,550

??? =SUMIF('2019'!$L:$L,(INDEX('2019'!$A$2:$M$500,0,MATCH(P$3,'2019'!$A:$A,0),MATCH($A5,'2019'!$E$1:$E$500,0))))

(I've omitted columns that are not relevant to my question in the sample below)

"SUMMARY" worksheet

	A	N	O	P
2	CAT			MTH
3				JAN
4
5	BINS			???
6	PARTS

<tbody>
</tbody>

"2019" worksheet

	A	E	L	M
1	MTH	CAT	AMT	CUST
2	JAN	BINS	5,000	BOB SMITH
3	JAN	PARTS	1,200	DAN PETERS
4	JAN	BINS	550	JASON BROWN
5	FEB	PARTS	250	SCOTT FINDE
6	FEB	BINS	2,500	BOB SMITH
7	FEB	MISC	150	DAN PETERS
8	FEB	PARTS	300	BOB SMITH

<tbody>
</tbody>

 

[GR00007]

This may meet your needs - it uses SUMIFS. The 2019 tab used is cloned from your example, but the summary used different cells.

CAT		JAN	FEB
BINS		5550	2500
PARTS		1200	550
MISC		0	150

<tbody>
</tbody>

=SUMIFS('2019'!L:L,'2019'!E:E,A2,'2019'!A:A,$C$1)
=SUMIFS('2019'!L:L,'2019'!E:E,A2,'2019'!A:A,$D$1)

There would be a slightly different formula for each month (the last criteria $C$1 for January and $D$1 for February, etc.), and the formulas can be copied down for to cover the categories.

 

[DEHA11]

This worked perfectly. Thanks!!