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

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

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

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

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

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

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