Oops. $ is absolute. My mistake...Dennis

"Dennis Allen" wrote in message
...
Thanks for the reply. Question. If I want to copy the countif() in the
same column, but different rows, is that =COUNTIF($A1:$A30,"X")?

Now if I can figure out how to print a summary version of each sheet and
link the numbers of each sheets to a summary sheet...Dennis

"MSP77079 " wrote in message
...
You want to do this in a macro or using a worksheet function?

If you just want to do it in a worksheet function, then put your cursor
where you want the result to be and click on "Insert Function".
Select the "Countif" function. The wizard will help you set up the
formula. You want something like this:

=COUNTIF(A1:A30,"X")


---
Message posted from http://www.ExcelForum.com/