Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting mixed cells | Excel Discussion (Misc queries) | |||
conditional counting with Excel | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting... | Excel Worksheet Functions |