Matrix formula ? Second try (no image)
Hi Pierre
One more option:
In K1:
=SUMPRODUCT(LOOKUP($C1:$I1,$A$1:$A$14,$B$1:$B$14))
Copy K1 down with the fill handle (the little square in the lower
right corner of the cell) if necessary.
--
Best Regards
Leo Heuser
Followup to newsgroup only please.
"Pierre Archambault" skrev i en meddelelse
...
Hi,
I need your help to solve a small formula problem.
A B C D E F G H I J K
1 0 1 3 4 5 9 11 12 = 3
2 0
3 0
4 1
5 1
6 0
7 0
8 1
9 0
10 1
11 0
12 1
13 0
14 0
I need to count in C1:I1 range, the number of times a given number appears
next to a "1" in the two
columns A1:B14
In this exemple, the answer is 3 because only the 4, 5 and 12 are
associated
with a "1" in the adjacent
column.
Thanks.
Pierre Archambault
|