How do I add the total of multiple columns based on date and the department?

[ibruzzi]

Hello guys,

I'm trying to add the total of multiple columns based on the given date and department. There are 8 tables on one sheet and I need the totals of all 8 (separate) columns on another sheet if the date and departments are a match and I want the totals to be in a table on another sheet. I feel like this should be pretty easy, but it confuses me as I try to come up with the formula.

The top table is where the totals should come. I copied only 3 tables because putting all 8 seemed redundant.

Any help will be much appreciated.

MACHINE OPERATING REPORT-1.XLSM
	A	B	C	D	E	F	G	H	I	J
3		HOUSEKEEPING	F&B	UNIFORMS	PERSONAL CLOTHES	SPA	FRONT OFFICE	GT	SEA	DIVE CENTER
4	01-Jul
5	02-Jul
6	03-Jul
7	04-Jul
8	05-Jul
9	06-Jul
10	07-Jul
11	08-Jul
12	09-Jul
13	10-Jul
14	11-Jul
15	12-Jul
16	13-Jul
17	14-Jul
18	15-Jul
Washers by Dept

Tables where data lies.

MACHINE OPERATING REPORT-1.XLSM
	A	B	C	D	E	F
1	DATE	DETAIL	DURATION	WEIGHT	TYPE	DEPARTMENT
2	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
3	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
4	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
5	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
6	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
7	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
8	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
9	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
10	03-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
11	03-02-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
12	04-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
13	04-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
14	04-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
15	04-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
16	04-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
17	04-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
18	04-07-21	BATH TOWEL	1:30	2	HK REGULAR LINEN	HOUSEKEEPING
Washing

MACHINE OPERATING REPORT-1.XLSM
	I	J	K	L	M	N
1	DATE	DETAIL	DURATION	WEIGHT	TYPE	DEPARTMENT
2	06-05-21	NAPKINS	1:30	3	F&B MAIN	F&B
3	06-05-21	NAPKINS	1:30	3	F&B MAIN	F&B
4	06-05-21	NAPKINS	1:30	3	F&B MAIN	F&B
5	06-05-21	NAPKINS	1:30	3	F&B MAIN	F&B
6	07-06-22	BATH TOWEL	1:00	3	GT MAIN	GUEST TRANSPORT
7	07-06-22	BATH TOWEL	1:00	3	GT MAIN	GUEST TRANSPORT
8	07-06-22	BATH TOWEL	1:00	3	GT MAIN	GUEST TRANSPORT
9	07-06-22	BATH TOWEL	1:00	3	GT MAIN	GUEST TRANSPORT
10	07-06-22	BATH TOWEL	1:00	3	GT MAIN	GUEST TRANSPORT
11	07-06-22	BATH TOWEL	1:00	3	GT MAIN	GUEST TRANSPORT
12	07-06-22	BATH TOWEL	1:00	3	GT MAIN	GUEST TRANSPORT
13
14
15
16
17
18
Washing

MACHINE OPERATING REPORT-1.XLSM
	Q	R	S	T	U	V
1	DATE	DETAIL	DURATION	WEIGHT	TYPE	DEPARTMENT
2	04-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
3	04-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
4	04-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
5	04-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
6	06-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
7	06-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
8	06-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
9	06-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
10	10-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
11	10-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
12	10-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
13	10-07-21	NAPKINS	1:20	55	F&B MAIN	F&B
14
15
16
17
18
Washing

 

[jorismoerings]

Hi,

Take a look at this. Didn't include all tables but just 2 to give the xample:

slot size.xlsx
	A	B	C	D	E	F	G	H	I	J
1		HOUSEKEEPING	F&B	UNIFORMS	PERSONAL CLOTHES	SPA	FRONT OFFICE	GUEST TRANSPORT	SEA	DIVE CENTER
2	1-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
3	2-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
4	3-7-2021	13:30:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
5	4-7-2021	10:30:00	06:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
6	5-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
7	6-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	04:00:00	00:00:00	00:00:00
8	7-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
9	8-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
10	9-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
11	10-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	03:00:00	00:00:00	00:00:00
12	11-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
13	12-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
14	13-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
15	14-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
16	15-7-2021	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00	00:00:00
washers by dept

Cell Formulas
Range	Formula
B2:J16	B2	=SUMIFS(washing!$C$2:$C$18,washing!$F$2:$F$18,B$1,washing!$A$2:$A$18,$A2)+SUMIFS(washing!$K$2:$K$18,washing!$N$2:$N$18,B$1,washing!$I$2:$I$18,$A2)