Sumproduct Index Match Maybe?

[rehberger]

Hello, I am trying to come up with a formula that i can drag to sum just the weekdays from the data set up below:
[TABLE="width: 200"]
<tbody>[TR]
[TD][/TD]
[TD]Weekdays[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2019[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Rooms[/TD]
[TD]Revenue[/TD]
[/TR]
[TR]
[TD]Casino[/TD]
[TD]Formula[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]Events[/TD]
[TD]Formula[/TD]
[TD]Formula[/TD]
[/TR]
</tbody>[/TABLE]

Data looks like this:
[TABLE="width: 300"]
<tbody>[TR]
[TD][/TD]
[TD]Casino[/TD]
[TD]Casino[/TD]
[TD]Events[/TD]
[TD]Events[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2019[/TD]
[TD]2019[/TD]
[TD]2019[/TD]
[TD]2019[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Rooms[/TD]
[TD]Revenue[/TD]
[TD]Rooms[/TD]
[TD]Revenue[/TD]
[/TR]
[TR]
[TD]1/1/19
[/TD]
[TD]10[/TD]
[TD]200[/TD]
[TD]20[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]1/2/19[/TD]
[TD]15[/TD]
[TD]300[/TD]
[TD]22[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]1/3/19[/TD]
[TD]12[/TD]
[TD]500[/TD]
[TD]20[/TD]
[TD]450[/TD]
[/TR]
[TR]
[TD]1/4/19[/TD]
[TD]5[/TD]
[TD]100[/TD]
[TD]10[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]1/5/19[/TD]
[TD]10[/TD]
[TD]200[/TD]
[TD]15[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]1/6/19[/TD]
[TD]15[/TD]
[TD]300[/TD]
[TD]15[/TD]
[TD]200[/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Excel Workbook
	A	B	C	D	E
1	Weekdays
2		2019
3		Rooms	Revenue
4	Casino	42	1100
5	Events	72	1450
6
7
8
9		Casino	Casino	Events	Events
10		2019	2019	2019	2019
11		Rooms	Revenue	Rooms	Revenue
12	1/1/2019	10	200	20	400
13	1/2/2019	15	300	22	300
14	1/3/2019	12	500	20	450
15	1/4/2019	5	100	10	300
16	1/5/2019	10	200	15	200
17	1/6/2019	15	300	15	200
Sheet5

 

[jtakw]

Hi,

If I understand correctly.

Change/adjust cell references/range as needed, formula copied down and across:

Book1
	A	B	C	D	E	F	G	H	I
1	Weekdays					Casino	Casino	Events	Events
2		2019				2019	2019	2019	2019
3		Rooms	Revenue			Rooms	Revenue	Rooms	Revenue
4	Casino	42	1100		1/1/2019	10	200	20	400
5	Events	72	1450		1/2/2019	15	300	22	300
6					1/3/2019	12	500	20	450
7					1/4/2019	5	100	10	300
8					1/5/2019	10	200	15	200
9					1/6/2019	15	300	15	200
Sheet549

Cell Formulas
Range	Formula
B4	=SUMPRODUCT(($F$1:$I$1=$A4)*($F$2:$I$2=$B$2)*($F$3:$I$3=B$3)*(WEEKDAY($E$4:$E$9,2)<6)*$F$4:$I$9)

 

[rehberger]

Works great! thanks!

 

[jtakw]

You're welcome.