How can I copy the sum of a filtered column into a cell in anothe
in [Functions]
|
Prev: Sumproduct Question Working With Start and End Date Range
Next: Returning a value if multiple conditions are met
From: ToffeeCoffee on 27 May 2010 17:11 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?
From: Mike H on 27 May 2010 17:44
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? |