IFERROR (AVERAGEIFS....) Question - error it says too many arguments

[Destined]

I have this formula and it is telling me too many arguments. How do i fix it? Since i need all these criteria to determine the salaries? Salary is based on student enrollment, ranking, length of service, and credit weight. can someone help?

=IFERROR(AVERAGEIFS('Salary Layout'!H:H,'Salary Layout'!A:A,FacultyData!A3,'Salary Layout'!D:D,"<="& FacultyData!B3,'Salary Layout'!E:E,">="&FacultyData!B3,'Salary Layout'!F:F,"<="&FacultyData!C3,'Salary Layout'!G:G,">="&FacultyData!C3), ‘Salary Layout’!B:B,“<=”&FacultyData!M3,’Salary Layout’!C:C,”>=”&FacultyData!M3),“Unknown”)

My two worksheets are:
Salary Layout worksheet:
[TABLE="width: 1037"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]Faculty Rankings
[/TD]
[TD]Min Credit Weight
[/TD]
[TD]Max Credit Weight
[/TD]
[TD]Min. Length of Service
[/TD]
[TD]Max. Length of Service
[/TD]
[TD]Min. Student Enrollment
[/TD]
[TD]Max. Student Enrollment
[/TD]
[TD]Salaries
[/TD]
[/TR]
</tbody>[/TABLE]
FacultyData Worksheet:
[TABLE="width: 1211"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[TD]L
[/TD]
[TD]M
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Faculty Ranking
[/TD]
[TD]Length of Service
[/TD]
[TD]Student Enrollment
[/TD]
[TD]Credit
[/TD]
[TD]Salary
[/TD]
[TD]Saln
[/TD]
[TD]Firstname
[/TD]
[TD]Lastname
[/TD]
[TD]EMP#
[/TD]
[TD]SSN
[/TD]
[TD]Dept.
[/TD]
[TD]Course #
[/TD]
[TD]Section
[/TD]
[TD]Term
[/TD]
[/TR]
</tbody>[/TABLE]

thanks much
Destined

 

[Aladin Akyurek]

in FacultyData worksheet i A4 - Ranking (e.g. senior), B4 is length of service (eg. 5 years), c4 is student enrollment (15 students), d4 is credit (2 credits). in Salary Layout A is Ranking, B is credit, C is Min Length of Service, D is Maximum Length of service, E is Min Student Enrollment and F is Max student enrollment. Hope i am answering your question.
Thanks,
D

Salary Layout >> sal

In F4 of FacultyData enter:

=AVERAGEIFS(sal!G:G,sal!A:A,A4,sal!B:B,D4,sal!C:C,">="&B4,sal!D:D,"<="&B4,sal!E:E,">="&C4,sal!F:F,"<="&C4)

Adjust to suit.

 

[Destined]

Aladin, you are a GENIUS in my books. I adapted the formula and viola it works. Thank you soooooooooooooo.... much for your help and your time. Much appreciate it.

Destined

 

[Aladin Akyurek]

Aladin, you are a GENIUS in my books. I adapted the formula and viola it works. Thank you soooooooooooooo.... much for your help and your time. Much appreciate it.

Destined

Glad to help. Thanks for the update.