Ignore the Values in hidden columns.

[mabubakerali]

Just like we use Aggregate function to ignore the values in hidden rows and ignore error and subtotals, is there any way we can do the same but with columns since aggregate function isnt working for columns, e.g i have 2 in column A , 3 in column B and 4 in column C and their sum is in column D, but if i hide column B i want excel to ignore the values in Column B and show the sum which is 6.

 

[SunnyAlv]

Like this ?

=SUM(IF(CELL("width",OFFSET(A1:D1,,SEQUENCE(,COLUMNS(A1:D1),0))),A1:D1))

**Before Hide column B

**After Hide Column B