Average if Help
I'm trying to calculate average salaries by for a grade within a payroll
I've got two named ranges - one is called 'grade' the other 'salary'. These
contain the grades and salaries of all staff
I'm trying to enter an array formula along the lines of
=average(if(grade=1),salary)
However, I can't get the syntax right as I keep getting error messages. I've
done the obvious things like check the range naming, etc. but can't get the
formulae right.
Can SKS help. TIA
Regards,
Robin
|