Use COUNTIF
--
Brevity is the soul of wit.


"fiur" wrote:

Hi can anyone tell me how to count:

name result
a 0
b 1
b 0
c 1
c 1

in another cheet I wanna count number of "a", "b", "c" and so on who has 1
or 0