Source: software-carpentry.org
Question:
I need to summarize the data in column C, if the column a and b contain certain values...
Data below:
A B C
TeamLevelVacanciesJoe24Joe23Joe32Andrew43Andrew24Kelly11Sarah25
The 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 Sarah
Answer:
With the teams in the column a from line 2: = sumifs(C2:C12,A2:A12,"Joe",B2:B12,1), but only in XL2007 + in the previous version, use SUMPRODUCT. Best wishes
Home
Add Your Article
Categories
Search Something
Latest Buzz
Related Buzz
0 Comments