Counting Visible Columns

I'm trying to count the # of visible columns, and thought this could be done using the Subtotal function?

When I use this, it returns the count of all the columns, and not just what is visible?

Please Login or Register  to view this content.

I tried with Subtotal 2, 3, 102, and 103 and all return the count of all of the columns.

Is there another approach to get the count or sum of visible columns?

i doubt it. microsoft would not consider hidden cols when writing basic features like this. the average user is who they target. those are the buyers. I'm not sure why you're even saying that the function counts cols. it's not suppose to according to this:

https://support.microsoft.com/en-us/...0-e478765b9939

it's math only. but if what you say is true, then by some miracle there might be a ""hidden col"" attribute. but the article doesn't say it. it says this:

The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using a function_num of 101 or greater, such as SUBTOTAL(109,B2:G2), hiding a column does not affect the subtotal. But, hiding a row in a subtotal of a vertical range does affect the subtotal.

and this:

The SUBTOTAL function ignores any rows that are not included in the result of a filter, no matter which function_num value you use.

Yeah, unfortunately had to result to using a helper cell and getting the column widths to do it.

Maybe one day, they will add a built in function for it.