dynamic summing of an autofilter 'ed table
 

I have a very large table. I have placed and autofilter at the top of the
table.

Just below the table I have a placed a formula that says =SUM(F5:F760) and
it sums up column F.

Now if I use the autofilter to filter out some of the rows I'd like the sum
function to recognize this and sum only the rows that pass through the
filter. This doesn't seem to work. How do I do this? Thanks!

have a look in HELP index for SUBTOTAL

--
Don Guillett
SalesAid Software

"john boy" <john wrote in message
...
I have a very large table. I have placed and autofilter at the top of the
table.

Just below the table I have a placed a formula that says =SUM(F5:F760) and
it sums up column F.

Now if I use the autofilter to filter out some of the rows I'd like the
sum
function to recognize this and sum only the rows that pass through the
filter. This doesn't seem to work. How do I do this? Thanks!

=SUBTOTAL(9,F5:F760)


Regards,

Peo Sjoblom

"john boy" wrote:

I have a very large table. I have placed and autofilter at the top of the
table.

Just below the table I have a placed a formula that says =SUM(F5:F760) and
it sums up column F.

Now if I use the autofilter to filter out some of the rows I'd like the sum
function to recognize this and sum only the rows that pass through the
filter. This doesn't seem to work. How do I do this? Thanks!

Try this =sum($f:$f)


"Peo Sjoblom" wrote:

=SUBTOTAL(9,F5:F760)


Regards,

Peo Sjoblom

"john boy" wrote:

I have a very large table. I have placed and autofilter at the top of the
table.

Just below the table I have a placed a formula that says =SUM(F5:F760) and
it sums up column F.

Now if I use the autofilter to filter out some of the rows I'd like the sum
function to recognize this and sum only the rows that pass through the
filter. This doesn't seem to work. How do I do this? Thanks!

That will not at all

--
Regards,

Peo Sjoblom


"Brian Sells" wrote in message
...
Try this =sum($f:$f)


"Peo Sjoblom" wrote:

=SUBTOTAL(9,F5:F760)


Regards,

Peo Sjoblom

"john boy" wrote:

I have a very large table. I have placed and autofilter at the top of
the
table.

Just below the table I have a placed a formula that says =SUM(F5:F760)
and
it sums up column F.

Now if I use the autofilter to filter out some of the rows I'd like the
sum
function to recognize this and sum only the rows that pass through the
filter. This doesn't seem to work. How do I do this? Thanks!