Hi guys,

If I use :

subtotal(109, "A1:A10") then it will only sum the visible rows

However, if I do
subtotal(109, "A1:H1") then it ignores the visible or hidden columns are all counted....

How can I do a subtotal horizontal on columns, ignoring the cells in hidden columns?

Thanks!