I'm totally unsure how to approach this problem...thus the post!
I have a list of three columns 'Name Task Hours'. am I am totalling the hours for each person. What I need the user to be able to do is to decide which of the tasks need to be included in the total for each person.
For example with the list...
Name Task Hours
Bob Gardening 8
Tom Walking 5
Bob Walking 4
Trevor Jumping 2
Bob Jumping 4
Tom Gardening 7
I need the user to be able to select what tasks should be used in determining the total. So in the above list, if the user decides to include Gardening and Walking the results would be...
Bob 12
Tom 5
Trevor 0
My initial idea is to create a dynamic list of tasks and have the user put in an 'X' in the cell next to the task name, but then how do I do the conditional sum (which currently uses SUMPRODUCT) if the task name is going to be different depending on the original data??
Very stuck on how to approach this one!!
I have a list of three columns 'Name Task Hours'. am I am totalling the hours for each person. What I need the user to be able to do is to decide which of the tasks need to be included in the total for each person.
For example with the list...
Name Task Hours
Bob Gardening 8
Tom Walking 5
Bob Walking 4
Trevor Jumping 2
Bob Jumping 4
Tom Gardening 7
I need the user to be able to select what tasks should be used in determining the total. So in the above list, if the user decides to include Gardening and Walking the results would be...
Bob 12
Tom 5
Trevor 0
My initial idea is to create a dynamic list of tasks and have the user put in an 'X' in the cell next to the task name, but then how do I do the conditional sum (which currently uses SUMPRODUCT) if the task name is going to be different depending on the original data??
Very stuck on how to approach this one!!