I would like to sum how many instances person "X, Y and Z" (see row 1) have been involved in task "A,B and C" (see coloumn 1) in excel. The result should be as shown in the bottom. I'm not that familiar with functions in Excel and have tried searching after a function that would calculate this..... without luck....I would like to sum how many instances person "
阅读背景：
Excel - 查找行/列表的组合结果
来源：互联网
分享到：
