I know you can use the "select only visible cells" option to select a group of visable cells when filtered or hidden, but this does not seem to work when I am entering a formula.
I hit the equall button and then the average button, here I can select cells with the mouse(on a filtered sheet), but when I hit the "select only visable cells" button, nothing changes