If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|