Count the total number of task a member being assigned to when one task may assigned to two people


Hi All,

What formula can I use to consolidate the number of task assigned for each member? Because i unable to write a good formula, then I need to form all these possibility combination. I have more than 20 combination and it is difficult for the member to read in the chart.

Popular Tags:

Best Answer

  • Ramzi KRamzi K ✭✭✭
    Accepted Answer

    @Lena Ho

    Lena, change @CELL to @cell (lower case).



    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (

    Feel free to email me: [email protected]

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.


Sign In or Register to comment.