Thread: Average if Help
View Single Post
  #1   Report Post  
RFJ
 
Posts: n/a
Default 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