Conditional sum based on user choice

[IanC]

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!!

 

[Chitosunday]

You are on the right track, use sumif function for example if your data is in a1:a10, put x beside it (which is column b) then use =sumif(b1:b10,"x",a1:a10)

 

[SIXTH SENSE]

hi!

take a look at this!
F6 thru H6 is data validation of task.
F2:F4=gardening
g2:g4=walking
g2:g4=jumping

Book1
	A	B	C	D	E	F	G	H
1	Name	Task	Hours		names	gardening	walking	jumping
2	Bob	Gardening	8		Bob	8	4	4
3	Tom	Walking	5		Tom	7	5	0
4	Bob	Walking	4		tRevor	0	0	2
5	Trevor	Jumping	2
6	Bob	Jumping	4			gardening	walking	jumping
7	Tom	Gardening	7		Bob	16
8	bob	Gardening	0		Tom	12
9					tRevor	2
10
Sheet2

you can click any combination of F6 thru H6 and the sum of
those combination will br shown rigth after names