need help with counting...

F

fiur

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
 
F

fiur

well thank you but I can't figure out how... I know how to count "a", "b" and
"c" but not how to "link" them to the result.....
Like:
sheet1:
name result
a 1
a 0
a 1
b 1
a 1
b 0
b 0
b 1
b 0

sheet2:
name result1 result2
a 3 1
b 2 3
 
R

Roger Govier

Hi

On sheet2 in cell B2
=SUMPRODUCT(($A$1:$A$100=$A2)*($B$1:$B$100=1))
in cell C2
=SUMPRODUCT(($A$1:$A$100=$A2)*($B$1:$B$100=0))

Copy both formulae down as far as required
Change ranges to suit.
 
Top