Try...
=SUMPRODUCT(--($A$2:$A$5="Yvonne"),--($B$2:$B$5=4),$C$2:$C$5)
or
=SUMPRODUCT(--($A$2:$A$5=E2),--($B$2:$B$5=F2),$C$2:$C$5)
....where E2 contains the name of interest, and F2 contains the week
number of interest.
Hope this helps!
In article ,
"Simon" wrote:
Hi I need to do a function, I have the following columns and some sample data
Name Week Number. Estimated Hours
Yvonne 4 2
Yvonne 4 3
Simon 4 5
Yvonne 5 1
What i want to do is, for each person i want to some their total estimated
hours for week 4.
So in pseudocode im trying to do this:
SUM the estimated hours where the name = Yvonne and the week number = 4.
The answer should be 5 for this example
Can someone please help me to do this, im struggling.
Thanks.
Simon
|