Formula visible cells

[Jenst]

Here is my question. In Sheet 1 I have the following formula written in a cell: =Task!B4. On Task! B4 is part of a filtered table. Is there a possibility to tell excel to only execute the formula if B4 is a visible cell at the moment? :think:

Thanks! Jens :hi:

[Jenst]

=IF(SUBTOTAL(103,Task!B4)=1,Task!B4,""), Solved thx !!