Hello Friends,

I have few column values to count. I don’t want the hidden column value. In that formula the hidden value also counted. Please help me to ignore that hidden column value count, using macro/formula.

eg:
col A - col B - col C - col D - col E - col F
Task -- ok1 -- ok2 -- no1 --- ok3 -- ok4

Col D should be hidden. Final count result should be: OK = 4; No=0

File attached for more clarification. No Count Hidden.xlsx