Is it possible to derive a countifs using two criteria with different array range - one horizontal and one vertical. Please see example below
<tbody>
</tbody>
i would to see how many pair of "1" for each name in G7, G8, G9, G10, H8, H9, H10, I9, I10, J10
i try these =COUNTIFS(G2:G6;1;B7:F7;1) but no luck
thanks
a | b | c | d | e | f | g | h | i | j | |
1 | Name | John | George | Alex | Allicia | |||||
2 | s1 | 1 | 1 | 0 | 0 | |||||
3 | s2 | 0 | 0 | 0 | 0 | |||||
4 | s3 | 1 | 0 | 1 | 0 | |||||
5 | s4 | 0 | 0 | 0 | 1 | |||||
6 | Name | s1 | s2 | s3 | s4 | s5 | 0 | 0 | 0 | 0 |
7 | John | 1 | 0 | 1 | 0 | 0 | ?? | |||
8 | George | 1 | 0 | 0 | 0 | 0 | ?? | ?? | ||
9 | Alex | 0 | 0 | 1 | 0 | 0 | ?? | ?? | ?? | |
10 | Allicia | 0 | 0 | 0 | 1 | 0 | ?? | ?? | ?? | ?? |
<tbody>
</tbody>
i would to see how many pair of "1" for each name in G7, G8, G9, G10, H8, H9, H10, I9, I10, J10
i try these =COUNTIFS(G2:G6;1;B7:F7;1) but no luck
thanks