Counting adjacent cells containing specific value

[colin5392]

I have a "x" in A2 and "x" in A3, again in A17/A18, again in A200/A201, etc.

How do I count the number of instances throughout the column of cells with adjacent (down) values?

And how would I do this for the entire dataset, which expands across from column A to column BT?

Can this be done without a macro?

 

[Peter_SSs]

Thanks a lot, Rick. It works perfectly.

In that case, if you are interested, I think this standard-entry formula should do the same job.

=COUNTIFS(A1:A33,"x",A2:A34,"")

 

[Usercode]

yes, it gives the same result. Thanks, Peter.

 

[Peter_SSs]

yes, it gives the same result. Thanks, Peter.

You are welcome.