| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I copy the sum of a filtered column into a cell in anothe
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I copy the sum of a filtered column into a cell in anothe
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. "ToffeeCoffee" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Paste filtered column ok in 2003 not in 2007 | Excel Worksheet Functions | |||
| Copy Filtered column in Full | Excel Discussion (Misc queries) | |||
| Copy data to filtered column | Excel Discussion (Misc queries) | |||
| how do i copy data from the top cell of a filtered list to anothe. | Excel Worksheet Functions | |||
| I need to copy table from one sheet to anothe | Excel Worksheet Functions | |||
Linear Mode
