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

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?
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I autosum a filtered column 1
Sum of filtered data 3
Copy/paste data across filtered rows 1
Sum all Values in a changing Column 15
Sum of rows in different columns 3
use month in cell date to sum all relevant cells 2
show last used cell in a column at the bottom of column. 3
Prevent functions from changing when new rows are added 1

Top