Sum cells visible after autofilter

[javelinmania]

I have two worksheets. In the second worksheet, I want to update the current cell with the sum of the values in a column of the visible rows of another worksheet - a worksheet with autofilter turned on so only a small portion of the overall rows will be visible. How do I do this?

 

[Jonmo1]

Welcome to the board...

Try the Subtotal Function...

=SUBTOTAL(109,A1:A100)

Hope that helps.

 

[wigi]

Hello there

You can do this using the SUBTOTAL function.