Summing values based on Weekend or weekday and of certain months

[jmb123]

Hello, I'd like to sum revenue of weekends of each month and revenue by weekdays of each month. I'd also like to average occupancy percentages by the same criteria. I was able to shade the rows based on weekday function, but I am having trouble creating a formula to sum the value based off being a weekend and in a certain month. To fully explain, there is another qualifier (A,R or T in picture). Thank you in advance

Weekend Revenue of category "A" in Jan, Feb, March etc.
Weekday Revenue of category "A" in Jan, Feb, March, etc.

Weekend average Occupancy of category "A" in Jan, Feb, March, etc.
Weekday average occupancy of category "A" in Jan, Feb, March , etc.

 

[Dave Patton]

We cannot work with a picture. Please post an extract of your data with the forum's tool named XL2BB.

You can review the following and expand it to address your requirements.

SumProduct 2022a.xlsm
	A	B	C	D	E	F	G
1	Date			Amount
2	Sat 01-Oct-22			220		Total	5200
3	Sun 02-Oct-22			250		Weekends	1360
4	Mon 03-Oct-22			280		Weekdays	3840
5	Tue 04-Oct-22			310
6	Wed 05-Oct-22			340
7	Thu 06-Oct-22			370
8	Fri 07-Oct-22			400
9	Sat 08-Oct-22			430
10	Sun 09-Oct-22			460
11	Mon 10-Oct-22			490
12	Tue 11-Oct-22			520
13	Wed 12-Oct-22			550
14	Thu 13-Oct-22			580
4a

Cell Formulas
Range	Formula
G2	G2	=SUM(D:D)
G3	G3	=SUMPRODUCT(--(WEEKDAY(A2:A14,2)>5),D2:D14)
G4	G4	=G2-G3

 

[jmb123]

I cannot get the add-in tool to record and every time i restart excel I have to "reopen" the add-in. I wish I could just simply email or upload and excel file.. is that possible? I appreciate your effort, but I guess I need to find another platform.

 

[Dave Patton]

You can check your system's settings.

see XL2BB Disappears when Excel is Reopened