Average ifs or function???

[cmholmes]

Hello, I have a question about the Average/if or AVERAGEIFS functions. I am trying to do an average of all the salaries for part time and full time employees, but the full time employees have a date range criteria that is different than the part time employees.

Full Time	7/1/14	12/31/14		Average Salary
Part Time	9/1/14	12/31/14		?
Name	Employer	Salary	Salary Type	Start Date	Benefits
John C	X0x	20000	P	12/1/14	N
Sarah M	XZ	40000	F	10/31/14	N
Jack F	XY	35000	F	8/20/14	Y
James R	YX	15000	P	9/15/14	N
Pat C	ZZ	45000	F	11/17/14	Y
Bob D	ZM	5000	P	5/2/14	N

<tbody>
</tbody>

 

[ghrain22]

You might have to do this with an array function or sumifs/countifs and manually calculate the average
(sumifs for part time + sumifs for full time)/(countifs for part time + countifs for full time)