Status Bar does not considering SUM in hidden columns, but consider hidden rows

[FelipeVaz]

Hi folks,

I have 3 columns (A, B, C), filled out with (1, 1, 1), A1:C1 = 3.
When I select a range of cells in a column and see the Status Bar the SUM is 3, it is OK.

But when I hide B column and select the range again, the Status Bar shows 2. Ok, Status Bar does not consider SUM in hidden columns or rows....

Ops, Try the same behavior in the rows (A1:A3)...does not work the same way!!!

A range of ROWS filled out with 1, hidding one of the values, select and see the Status Bar...2?

Why?? Weird...

P.S.: I tryed Excel 2013 Tablet version today, but it has opposite behavior (Status Bar DONT SUM hidden columns, rows SUM)

 

[FelipeVaz]

Ops...in the tablet version is the same...sorry.

Link to tests: http://1drv.ms/1RHT8ET

Hi folks,

I have 3 columns (A, B, C), filled out with (1, 1, 1), A1:C1 = 3.
When I select a range of cells in a column and see the Status Bar the SUM is 3, it is OK.

But when I hide B column and select the range again, the Status Bar shows 2. Ok, Status Bar does not consider SUM in hidden columns or rows....

Ops, Try the same behavior in the rows (A1:A3)...does not work the same way!!!

A range of ROWS filled out with 1, hidding one of the values, select and see the Status Bar...2?

Why?? Weird...

P.S.: I tryed Excel 2013 Tablet version today, but it has opposite behavior (Status Bar DONT SUM hidden columns, rows SUM)

 

[shg]

Rows and columns are not symmetric in Excel. Lots of functions ignore filtered or manually-hidden rows. Off the top of my head, none ignore hidden columns, and, of course, you can't filter columns.

 

[FelipeVaz]

Thks shg, really make sense.

Hugssss

Rows and columns are not symmetric in Excel. Lots of functions ignore filtered or manually-hidden rows. Off the top of my head, none ignore hidden columns, and, of course, you can't filter columns.

 

[shg]

You're welcome.