Sum of filtered worsksheet

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
 
W

William

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
 

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

hidden rows problem 7
Sum after Filter, Count after Fliter 2
How do I autosum a filtered column 1
Formulating cells 2
Ratio of growth over a filtered set 3
Access Sum function in an Access Form 1
sum of visable cells in filtered range 7
How to add only the adding filtered result using SUM function? 7

Top