Further solution proposal of question: https://www.experts-exchange.com/questions/29114446/
I would like to include the following requirements:
1-Perform the sum based on unique values of column F (Who)
2-Generate Output result in different sheets based on unique values of column F (Who)
By doing so we can have the vision for each (Who) defined in Input sheet split by sheets.
I attached an example file with required tabs.
If you have questions, please contact me.