hi, i having problem in Subtotal that visible column only.
need help
Ex:
COLUMN A - 10
COLUMN B - 5
COLUMN C - 3
RESULT WILL BE AT COLUMN D D: 6
but after i hide the COLUMN B. Result in COLUMN D does not change
here's my simple formula.
=subtotal(101,A1:C1)
Thanks and regards to all.
Bookmarks