That would work if the pattern were A3:A5,A9:A11,A15:A17, but unfortunately
it wasn't.

such as A3:A6,A9:A12,A15:A18?

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote in message
...
If they are structured as you show, you can use

=SUMPRODUCT(--(A3:A18="X"),--(MOD(INT(ROW(A3:A18)/3),2)=1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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