Thanks for the help Bob but unfortunately it didn't work. Formula is still counting all cells in list - even those hidden.