need help with counting...
 

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

need help with counting...
 

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

need help with counting...
 

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

need help with counting...
 

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

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