Exclude cells in SUM if they are hidden?

**Jonmo1** · 06-02-2015, 02:50 PM

Ah, those are in 'columns' not rows.

Subtotal won't work. I actually can't imagine any formula that would.

Is there anything common about which cells should be included?

You said you hide them with VBA, can you show that code?
What is the criteria that is used to hide/unhide a column?
That can likely be used in a sumif formula.

**Tony Valko** · 06-02-2015, 07:33 PM

Originally Posted by Jonmo1

I actually can't imagine any formula that would.

It's a real kludge...

Using helper cells...

=CELL("width",A1)

Then...

=SUMIF(Helper Cells,">0",Sum Range)

However, hiding cells does not trigger a calculation. Maybe they can put in a calculate event after they hide the cells.