SUMIF Formula more than one criteria

[markster]

Morning folks.
I know how to do a basic SUMIF formula based on a single criteria but I'm struggling to get it to work on more than one criteria.

I have a basic table and need to summarize number of teaching hours per subject per week

Book1
	A	B	C	D	E	F
4	Week ending	1-Oct-21	8-Oct-21	15-Oct-21	22-Oct-21	29-Oct-21
5	Week Number	1	2	3	4	5
6
7	XXXX Course Scheduled Teaching Hours
8	Business	5.0	10.5	3.0
9	Finance
10	Accounting
11
Delivery Req. by Programme

The source data is as follows:

Book1
	A	B	C	D	E	F	G	H	I	J
3	Area	Delivery Dates	Week End Date	Week	Scheduled Day	Size	Scheduled Start	Scheduled End	Duration2	Duration
4	Business	27/9/2021	1-Oct-21	1	Monday	9	14:00	15:00	1.0	1:00
5	Accounting	27/9/2021	1-Oct-21	1	Monday	9	11:00	13:00	2.0	2:00
6	Finance	27/9/2021	1-Oct-21	1	Monday	73	11:00	12:00	1.0	1:00
7	Business	28/9/2021	1-Oct-21	1	Tuesday	37	12:30	14:30	2.0	2:00
8	Accounting	28/9/2021	1-Oct-21	1	Tuesday	36	12:30	14:30	2.0	2:00
9	Finance	28/9/2021	1-Oct-21	1	Tuesday	33	11:00	13:00	2.0	2:00
10	Business	28/9/2021	1-Oct-21	1	Tuesday	33	15:00	17:00	2.0	2:00
11	Accounting	28/9/2021	1-Oct-21	1	Tuesday	19	15:00	17:00	2.0	2:00
12	Finance	28/9/2021	1-Oct-21	1	Tuesday	19	12:00	13:00	1.0	1:00
13	Business	10/4/2021	8-Oct-21	2	Monday	52	9:00	11:30	2.5	2:30
14	Accounting	10/4/2021	8-Oct-21	2	Monday	52	13:30	15:30	2.0	2:00
15	Finance	10/5/2021	8-Oct-21	2	Tuesday	20	9:30	11:30	2.0	2:00
16	Business	10/5/2021	8-Oct-21	2	Tuesday	19	13:00	14:00	1.0	1:00
17	Accounting	10/5/2021	8-Oct-21	2	Tuesday	19	14:00	16:00	2.0	2:00
18	Finance	10/5/2021	8-Oct-21	2	Tuesday	33	16:00	18:00	2.0	2:00
19	Business	10/7/2021	8-Oct-21	2	Thursday	0	10:00	17:00	7.0	7:00
20	Accounting	10/8/2021	8-Oct-21	2	Friday	18	10:00	13:00	3.0	3:00
21	Finance	10/8/2021	8-Oct-21	2	Friday	17	10:00	13:00	3.0	3:00
22	Business	10/11/2021	15-Oct-21	3	Monday	34	14:00	16:00	2.0	2:00
23	Accounting	10/11/2021	15-Oct-21	3	Monday	18	16:00	17:00	1.0	1:00
24	Finance	10/12/2021	15-Oct-21	3	Tuesday	20	9:30	12:30	3.0	3:00
25	Business	13/10/2021	15-Oct-21	3	Wednesday	30	14:00	15:00	1.0	1:00
26	Accounting	14/10/2021	15-Oct-21	3	Thursday	0	10:00	17:00	7.0	7:00
27	Finance	18/10/2021	22-Oct-21	4	Monday	0	9:00	17:00	8.0	8:00
Semester 1 Timetabling

Cell Formulas
Range	Formula
D4:D27	D4	=VLOOKUP(C4,'[NMAH Resource Planning v0.4.xlsx]Week Numbers'!F:G,2,0)

So you will see that my SUMIF formula in the first table will need to look at column A, D & sum the duration in column I in the second table to calculate number of hours scheduled teaching hours for each subject each week I have manually input the totals in the first table to illustrate what I need. Would appreciate any help. Thanks. M

 

[ChrisFoster]

Use SUMIFS

 

[earthworm]

I am not falling into your data . I suggest to try Sumifs formula for more than 1 criteria . The rest you will understanding accordinglyt.

 

[Phuoc]

You can use the SUMIFS() function.

 

[markster]

Yay - did it thanks.

=SUMIFS('Semester 1 Timetabling '!$I4:$I27,'Semester 1 Timetabling '!$A4:$A27,'Delivery Req. by Programme'!$A8,'Semester 1 Timetabling '!$D4:$D27,'Delivery Req. by Programme'!B5)