Sum if with a index/match problem

[SteveNL86]

Dear reader,

I'm trying to use a sumif formula with a index/match formula. I've got a table as such:

A - Name	B - FTE
Jim	1,0
Bob	1,5
Mary	1,6
Max	1,9
Anna	0,9
Marc	2,1
Nicole	1,1
Susan	1,3
Rose	1,6

Next to it I have the following data:

C - Date	D- Jim	E- Bob	F- Mary	G- Max	H - Anna	I- Marc	J - Nicole	K - Susan	L - Rose
15-01	Yes	No	No	No	Yes	No	No	No	Yes
16-01	Yes	No	No	No	Yes	No	No	No	Yes
17-01	No	Yes	No	Yes	Yes	No	No	No	Yes
18-01	No	Yes	No	No	Yes	No	No	No	Yes
19-01	No	Yes	No	No	Yes	No	No	No	No
20-01	No	Yes	No	No	Yes	No	Yes	No	No
21-01	No	Yes	No	No	No	No	Yes	No	No
22-01	No	Yes	No	No	No	No	Yes	No	No
23-01	No	Yes	No	No	No	No	No	No	No

In column M I'm trying to count the sum of FTE of the people that have 'Yes' on that date. So for 15-01 it would be the sum of 1,0+0,9+1,6=3,5.

Edit: In addition, I have a column N with weeknumbers (1 to 52). In column O I'm trying to count the number of Yes results per week.

Any help is much appreciated!

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	A - Name	B - FTE	C - Date	Jim	Bob	Mary	Max	Anna	Marc	Nicole	Susan	Rose
2	Jim	1	15-Jan	Yes	No	No	No	Yes	No	No	No	Yes	3.5
3	Bob	1.5	16-Jan	Yes	No	No	No	Yes	No	No	No	Yes	3.5
4	Mary	1.6	17-Jan	No	Yes	No	Yes	Yes	No	No	No	Yes	5.9
5	Max	1.9	18-Jan	No	Yes	No	No	Yes	No	No	No	Yes	4
6	Anna	0.9	19-Jan	No	Yes	No	No	Yes	No	No	No	No	2.4
7	Marc	2.1	20-Jan	No	Yes	No	No	Yes	No	Yes	No	No	3.5
8	Nicole	1.1	21-Jan	No	Yes	No	No	No	No	Yes	No	No	2.6
9	Susan	1.3	22-Jan	No	Yes	No	No	No	No	Yes	No	No	2.6
10	Rose	1.6	23-Jan	No	Yes	No	No	No	No	No	No	No	1.5
Lists

Cell Formulas
Range	Formula
M2:M10	M2	=SUMPRODUCT((D2:L2="Yes")*($D$1:$L$1=$A$2:$A$10)*($B$2:$B$10))

 

[SteveNL86]

Thank you so much Fluff, that works perfectly.

I'll try to see if I can find a way to count the numbers of Yes per week.

 

[Fluff]

You're welcome & thanks for the feedback.