dynamic summing of an autofilter 'ed table

[Guest]

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!

 

[Don Guillett]

have a look in HELP index for SUBTOTAL

 

[Guest]

=SUBTOTAL(9,F5:F760)


Regards,

Peo Sjoblom

 

[Guest]

Try this =sum($f:$f)

=SUBTOTAL(9,F5:F760)


Regards,

Peo Sjoblom

 

[Peo Sjoblom]

That will not at all

--
Regards,

Peo Sjoblom

Try this =sum($f:$f)