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

"mangesh_yadav " wrote in
message ...
Although I couldn't figure out exactly what you need, but I guess you
require something like

A B C D E
1 C1 C2 C3 C4 Total
2 X X X =COUNTIF(A2:D2,"X")
3
4

- Mangesh


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