I want to AVERAGEIFS a subset of employee types to calculate their average salary.

[maxim642]

I want to know the average salary (column E) for employees at the company. "Employee" & "Employee Fixed Term" are categorised as employees, so I just want to average those two employee types (column J) combined.

Cell B10 should have the formula in it.

Thank you.

8.3.21 HR Dashboard ML.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1	Full Name	Employee Number	Job Title	Job Level	Salary	Company	Division	Department	Status	Employee Type	Manager Full Name	Start Date	Continuous Start Date	Leaving Date	Location	Gender	Email	Contract End Date	Standard Hours	Disabled	Car Allowance	Actual FTE	Cost Centre	Ethnicity	LoS Date	Full Time Y/N	Start Year	Start Month	Leave Year	Leave Month	LoS (Days)	Los (Years)	Actual Start Date	Formatted Leave Date
2	Worker1	1	Job1	20	$418,000	LTD1	Team1	Dep1	Current	Employee	Man1	1/13/11			London	Male	N/A		37.5	No	0	1	N/A	White - Any other background	3/15/21	Yes	2011	Jan			3714	10.2	1/13/11
3	Worker2	2	Job2	20	$360,000	LTD1	Team1	Dep1	Current	Employee Fixed Term	Man1	3/1/19			London	Male	N/A		37.5	No	0	1	N/A	White - English, Welsh, Scottish, Northern Irish, British	3/15/21	Yes	2019	Mar			745	2.0	3/1/19
4	Worker3	3	Job3	20	$350,000	LTD1	Team1	Dep1	Current	Employee	Man1	1/11/21			London	Male	N/A		37.5	No	0	1	N/A	White - English, Welsh, Scottish, Northern Irish, British	3/15/21	Yes	2021	Jan			63	0.2	1/11/21
5	Worker4	4	Job4	20	$300,000	LTD1	Team1	Dep1	Current	Contractor	Man1	1/4/21			London	Female	N/A		37.5	No	0	1	N/A	White - English, Welsh, Scottish, Northern Irish, British	3/15/21	Yes	2021	Jan			70	0.2	1/4/21
6	Worker5	5	Job5	20	$300,000	LTD1	Team1	Dep1	Former	Employee	Man1	1/1/12		7/15/20	London	Male	N/A		37.5	No	0	1	N/A	White - English, Welsh, Scottish, Northern Irish, British	7/15/20	Yes	2012	Jan	2020	Jul	3118	8.5	1/1/12	7/15/20
7	Worker6	6	Job6	20	$269,000	LTD1	Team1	Dep1	Current	Employee	Man1	9/30/19			Brighton	Male	N/A		37.5	No	0	1	N/A	White - English, Welsh, Scottish, Northern Irish, British	3/15/21	Yes	2019	Sep			532	1.5	9/30/19
8
9
10	Average Salary
Sheet1

 

[steve the fish]

Looking at that you could just use:

=AVERAGEIFS(E:E,J:J,"Employee*")

 

[maxim642]

Looking at that you could just use:

=AVERAGEIFS(E:E,J:J,"Employee*")

Thanks...I completely forgot about the wildcard option! Doh! Much appreciated.