How can I copy the sum of a filtered column into a cell in anothe

  • Thread starter Thread starter ToffeeCoffee
  • Start date Start date
T

ToffeeCoffee

How can I copy the sum of a filtered column into a cell in another worksheet
so that when changes are made within the column the change in the sum also
appears in the single cell in the other worksheet?
 
Hi,

You don't say so but because you mention 'filtered' I assume you want only a
total of the visible rows. Is that correct?

If so try this

=SUBTOTAL(109,Sheet1!A2:A20)


where A2 to A20 is the full and un-filtered range
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top