Look in the help index for SUBTOTAL and pay special attention to hidden rows
part.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Anuma (GGK Tech)" wrote in message
...
Hi,

I need to display the Count of distinct values and also ignore hidden rows
in the count.
Please help me to fix this issue.