I have some cells that all have some number of references to cells in Column A. I'd like to count each of two types references in each cell: the number of references to visible cells and the number of references to hidden cells.

Is there any way to do this??

Thanks,
Kate