Dear reader,
I'm trying to use a sumif formula with a index/match formula. I've got a table as such:
Next to it I have the following data:
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!
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!
Last edited: