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



"Arturo" wrote:

=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