How to total only visible columns or rows after filtering

**slipit1** · 12-01-2009, 10:16 AM

Hello,

I have filtered a worksheet and want to only total the data in the columns that are visable, is this possible?

**NBVC** · 12-01-2009, 10:17 AM

Yes, using SUBTOTAL() function

See that function in Excel help

e.g

=Subtotal(9,A1:A100) will sum visible cells in A1:A100
=Subtotal(3,A1:A100) will count visibil cells in A1:A100

**Jack in the UK** · 12-01-2009, 10:30 AM

Try lloking at : Excel Built In Function

=Subtotal(9,

Compleat this as your required adding Your range

Jack in the UK

**slipit1** · 12-01-2009, 04:57 PM

I can't believe it is that simple, thank you! Note: i also found you can copy/paste special/validation, it is a longer process.

**NBVC** · 12-01-2009, 05:20 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save