In general, each would have to be handled separately, but if the intervening
cells would not contain an X, then you wouldn't need to exclude them to get
the count.

=Countif(A3:A6,"X")+Countif(A9:A12,"X")+Countif(A1 5:A18,"X")

--
Regards,
Tom Ogilvy


"Arturo" wrote in message
...
=COUNTIF(A3:A6,"X")

Returns the correct # of Xs in that range.
How do I incorporate additional non-contiguous ranges into that formula
correctly, such as A3:A6,A9:A12,A15:A18?

Sincerely,
Arturo