Sum row with hidden columns.

Hi,

How can I collect the numbers in A2: K2, given that we columns hidden in this range. So I would like to gather numbers of cells visible.

Thank you.

Let’s refer to article in the following thread which discusses about a similar and see if it helps: https://www.extendoffice.com/documen...s-or-rows.html

user defined function

Please Login or Register  to view this content.

Thank you, both of you.