Sum of filtered worsksheet

  • Thread starter Thread starter Leighton Barnish
  • Start date Start date
L

Leighton Barnish

I currently have an application that outputs to MS Excel
with totals at the bottom and autofilters in place for
applicable columns.

If I apply the filter, the total at the bottom remains
that of all rows and not the filtered totals. How can I
create a second totals row for the sum of the filtered
data only?

Please mail me directly
 
Hi

=SUBTOTAL(9,C2:C100)

--
XL2002
Regards

William

(e-mail address removed)

| I currently have an application that outputs to MS Excel
| with totals at the bottom and autofilters in place for
| applicable columns.
|
| If I apply the filter, the total at the bottom remains
| that of all rows and not the filtered totals. How can I
| create a second totals row for the sum of the filtered
| data only?
|
| Please mail me directly
 
Back
Top