Hello,
I need a formula that provides the average of salaries based on the following criteria.
Provide the average of salary, if Grade = X and Department =Y and Type = A or B.
Also, is it possible to add the iserror formula so that I dont get the #DIV/0 error for grades that dont have data?
Thanks for your help.
Bookmarks