Hello !!
I got two sheets ("data" and "statistic") in one I got two clomuns one with numbers and another with names like in the example:
in "data" sheet :
A ---B
1 ---John
0 ---Danny
6 ---Mary
0 ---John
24 --Danny
0 ---Mary
I want (in sheet two "statistic") to count each time 0 appears on each name
something like:
IF B="John" and A=0 COUNT 1
I got two sheets ("data" and "statistic") in one I got two clomuns one with numbers and another with names like in the example:
in "data" sheet :
A ---B
1 ---John
0 ---Danny
6 ---Mary
0 ---John
24 --Danny
0 ---Mary
I want (in sheet two "statistic") to count each time 0 appears on each name
something like:
IF B="John" and A=0 COUNT 1
