=SUMPRODUCT(--(COUNTIF(OFFSET(C12,ROW(A1:A25)-1,,1,2),"*X*")0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
The tips have been very helpful!

For the formula that Bob provided,
=SUMPRODUCT(--(COUNTIF(OFFSET(A1,ROW(A1:A25)-1,,1,2),"*X*")0)), which
variables need to be updated if I move my data, say from A1:E25 to
C12:G37 (I need to insert some columns and rows surronding the table of
data)?

Thank you!
TKO