The sum of cells in column C, if the column a and b are some values

Office

Question:I need to summarize the data in column C, if the column a and b contain certain values...Data below:A B CTeamLevelVacanciesJoe24Joe23Joe32Andrew43Andrew24Kelly11Sarah25The response must go in the below:That is, if the team Joe, and level 2 then count the number of vacancies in column c (the answer should be 7) Level12344 55TeamJoe Andrew Kelly SarahAnswer:With the teams in the column a from...Read More

Posted: 21 Feb 2012

Tags: The sum of cells in column C if the column a and b are some values The sum cells column the and are some values