Formula find the average of positive Hours based on multiple criteria

[Lukma]

Hi guys

am Having little doubt how to go about this, finding the average of the positive hours and to ignore the negative hours based on criteria

from my table i have the Criteria List G, H which i need to find the average positive for each monthly and ignore the negative hours

Appreciate with a solution for the formula

Regards

ILSP KPI Performance Tracking.xlsx
	B	C	D	E	F	G	H
1	Monthly Mus End Date	Vls Deck	Total Exceed Hrs Cargo Start Time Cargo End Time		01-Jan-21	Half	Full
2	01-Jan-21	Half	-7		Average of positive
3	01-Jan-21	Half	1
4	01-Jan-21	Half	3
5	01-Jan-21	Half	-4
6	01-Jan-21	Full	-1
7	01-Jan-21	Half	-9
8	01-Jan-21	NAF	-0
9	01-Jan-21	Half	-6
10	01-Jan-21	Half	-1
11	01-Jan-21	Half	-5
12	01-Jan-21	Full	-3
13	01-Jan-21	Half	-3
14	01-Jan-21	Full	0
15	01-Jan-21	Full	-7
16	01-Jan-21	Full	-4
17	01-Jan-21	Half	-1
18	01-Jan-21	Half	-14
19	01-Jan-21	Half	-6
20	01-Jan-21	Half	3
21	01-Jan-21	Full	14
22	01-Jan-21	Half	-14
23	01-Jan-21	Half	-6
24	01-Jan-21	Half	3
25	01-Jan-21	Half	14
26	01-Jan-21	Full	-8
27	01-Jan-21	Half	-4
28	01-Jan-21	NAF	-8
29	01-Jan-21	Half	0
30	01-Jan-21	Half	-12
31	01-Jan-21	Half	-4
32	01-Jan-21	Full	7
33	01-Jan-21	Half	-8
34	01-Jan-21	Full	-5
35	01-Jan-21	Full	-6
36	01-Feb-21	Full	-10
37	01-Feb-21	Half	-0
38	01-Feb-21	Half	-6
39	01-Feb-21	Half	-8
40	01-Feb-21	Half	-14
41	01-Feb-21	Full	2
42	01-Feb-21	Half	29
43	01-Feb-21	Half	7
44	01-Feb-21	Half	4
45	01-Feb-21	Half	1
46	01-Feb-21	Full	0
47	01-Feb-21	Half	25
48	01-Feb-21	NAF	-18
49	01-Feb-21	Half	-10
50	01-Feb-21	Half	-4
51	01-Feb-21	Half	-8
52	01-Feb-21	Full	-4
53	01-Feb-21	Half	6
54	01-Feb-21	Full	-9
55	01-Feb-21	Full	-5
56	01-Feb-21	Full	14
57	01-Feb-21	Half	-7
58	01-Feb-21	Half	-3
59	01-Feb-21	Half	-5
60	01-Feb-21	Half	-1
61	01-Feb-21	Full	-18
62	01-Feb-21	Half	-13
Sheet2

 

[arthurbr]

Perhaps try the AVERAGEIFS function?

 

[Lukma]

HI Arthurbr

i thought as much great it works thanks