Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
plotted Average | Charts and Charting in Excel | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
What is this kind of average called? | Excel Worksheet Functions | |||
Average Formula with Criteria | Excel Discussion (Misc queries) | |||
average function in Excel 2002 | New Users to Excel |