Hi,

I have multiple columns and I have to apply some filters to arrange the data according to my need. The problem is that I want to apply Countifs formula as I need to count how many cells contains the specific value. But as soon as I give the range hidden cells are also included in that range.

Can any one help me here.