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