I need to verify for each row that B values are Y and count value in column A (count only one time each value)
<pre>
row A B
1 2 Y count 1
2 2 Y already counted
3 4 Y count 2
4 2 N
5 1 Y count 3
6 4 Y already counted
7 2 Y already counted
8
9 Total Y = 3
</pre>
I'm only near with sum.if but i'm not able to count only one time row 1, rov 2 and row 7 so as row 3 and row 6.
Tanks and regard
Simone
<pre>
row A B
1 2 Y count 1
2 2 Y already counted
3 4 Y count 2
4 2 N
5 1 Y count 3
6 4 Y already counted
7 2 Y already counted
8
9 Total Y = 3
</pre>
I'm only near with sum.if but i'm not able to count only one time row 1, rov 2 and row 7 so as row 3 and row 6.
Tanks and regard
Simone