need help with counting...
YES!!!!!!!!! thanx alot for your help!!!
you're the man!!
"Roger Govier" wrote:
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.
--
Regards
Roger Govier
"fiur" wrote in message
...
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
"Dave F" wrote:
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
|