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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Full Time
[/TD]
[TD]7/1/14
[/TD]
[TD]12/31/14
[/TD]
[TD][/TD]
[TD]Average Salary
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Part Time
[/TD]
[TD]9/1/14
[/TD]
[TD]12/31/14
[/TD]
[TD][/TD]
[TD]?
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[TD]Employer
[/TD]
[TD]Salary
[/TD]
[TD]Salary Type
[/TD]
[TD]Start Date
[/TD]
[TD]Benefits
[/TD]
[/TR]
[TR]
[TD]John C
[/TD]
[TD]X0x
[/TD]
[TD]20000
[/TD]
[TD]P
[/TD]
[TD]12/1/14
[/TD]
[TD]N
[/TD]
[/TR]
[TR]
[TD]Sarah M
[/TD]
[TD]XZ
[/TD]
[TD]40000
[/TD]
[TD]F
[/TD]
[TD]10/31/14
[/TD]
[TD]N
[/TD]
[/TR]
[TR]
[TD]Jack F
[/TD]
[TD]XY
[/TD]
[TD]35000
[/TD]
[TD]F
[/TD]
[TD]8/20/14
[/TD]
[TD]Y
[/TD]
[/TR]
[TR]
[TD]James R
[/TD]
[TD]YX
[/TD]
[TD]15000
[/TD]
[TD]P
[/TD]
[TD]9/15/14
[/TD]
[TD]N
[/TD]
[/TR]
[TR]
[TD]Pat C
[/TD]
[TD]ZZ
[/TD]
[TD]45000
[/TD]
[TD]F
[/TD]
[TD]11/17/14
[/TD]
[TD]Y
[/TD]
[/TR]
[TR]
[TD]Bob D
[/TD]
[TD]ZM
[/TD]
[TD]5000
[/TD]
[TD]P
[/TD]
[TD]5/2/14
[/TD]
[TD]N
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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)