| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting numbers
how do i count the number of times lets say 1,2 and 3 are populated in cell
range A2 to d12? u guys are awesome such a big help -- thanx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting numbers
=countif(A2:D12,"1") etc.
Dave -- Brevity is the soul of wit. "dmack" wrote: how do i count the number of times lets say 1,2 and 3 are populated in cell range A2 to d12? u guys are awesome such a big help -- thanx |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting numbers
thanx Dave F, that works, now how would i find the number of times that all three are populated in the same string of cells in the same formula -- thanx "dmack" wrote: how do i count the number of times lets say 1,2 and 3 are populated in cell range A2 to d12? u guys are awesome such a big help -- thanx |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting numbers
Combine the countifs: =COUNTIF(A1:A10,"1")+COUNTIF(A1:A10,"2").... etc.
Dave -- Brevity is the soul of wit. "dmack" wrote: thanx Dave F, that works, now how would i find the number of times that all three are populated in the same string of cells in the same formula -- thanx "dmack" wrote: how do i count the number of times lets say 1,2 and 3 are populated in cell range A2 to d12? u guys are awesome such a big help -- thanx |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting numbers
Another way:
=SUM(COUNTIF(A2:d12,{1,2,3})) dmack wrote: thanx Dave F, that works, now how would i find the number of times that all three are populated in the same string of cells in the same formula -- thanx "dmack" wrote: how do i count the number of times lets say 1,2 and 3 are populated in cell range A2 to d12? u guys are awesome such a big help -- thanx -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting numbers
That's clever.
Dave -- Brevity is the soul of wit. "Dave Peterson" wrote: Another way: =SUM(COUNTIF(A2:d12,{1,2,3})) dmack wrote: thanx Dave F, that works, now how would i find the number of times that all three are populated in the same string of cells in the same formula -- thanx "dmack" wrote: how do i count the number of times lets say 1,2 and 3 are populated in cell range A2 to d12? u guys are awesome such a big help -- thanx -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting numbers
I thought the same thing when I first saw it in the newsgroups!
Dave F wrote: That's clever. Dave -- Brevity is the soul of wit. "Dave Peterson" wrote: Another way: =SUM(COUNTIF(A2:d12,{1,2,3})) dmack wrote: thanx Dave F, that works, now how would i find the number of times that all three are populated in the same string of cells in the same formula -- thanx "dmack" wrote: how do i count the number of times lets say 1,2 and 3 are populated in cell range A2 to d12? u guys are awesome such a big help -- thanx -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this possible ??? | Excel Discussion (Misc queries) | |||
| Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Counting numbers in a column without including others | Excel Worksheet Functions | |||
| Counting multiple numbers in one cell | Excel Worksheet Functions | |||
Hybrid Mode
