no i need it to meet both criterias in order for it to count them...maybe a
macro would suite better for this?

--
--Chip Smith--
MVP Wannabe :)


"CLR" wrote:

If you just want the SUM of the two counts, then........

=countif(range,criteria)+countif(range,criteria)

Vaya con Dios,
Chuck, CABGx3



"Chip Smith" wrote:

i need to do a count based on two differnt criteria and two different
ranges...like a =countif((range,criteria)&(range,criteria)) or something of
that nature
--
--Chip Smith--
MVP Wannabe :)