Total Team Members with correct Team Leader
Hi, I'm new and hello!
I need direction on what type of formula to use.
Looking for a way to total team members to team leaders. Array of Sumifs!
Example..
Member1=1
Member2=5
Member3=12
Member2 is on a different team, so the answer I need is the total of 1&3 which would be 13.
Please see spreadsheet.
Many thanks
I would make a map, which you have already started and then use a sumif formula as in the attached workbook.
Test_Book.xlsx
Let me know if you have any questions.
Also, you will see you have a name that is NOT in the map of leader to team member.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thanks Mike. I'll give that a go.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks