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
[email protected]
"john boy" <john [email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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!
>> >