Hello,
Is there a way to exclude hidden columns from a calculation?
For example, say in C3 i have =A1+B1.
In cell A1 is 4
In cell B1 is 12
Is there a way to make excel show 4 in C3 when i hide column B? (without changing the formula in C3 to =A1, obviously)
Thx!
Ben
Is there a way to exclude hidden columns from a calculation?
For example, say in C3 i have =A1+B1.
In cell A1 is 4
In cell B1 is 12
Is there a way to make excel show 4 in C3 when i hide column B? (without changing the formula in C3 to =A1, obviously)
Thx!
Ben