Filtering

[maverick9576]

Ok this may be a stupid question but here it goes anyway. I have
columns. One column lists hours, next column lists names. Now i
the names column I have autofiltering set up. At the bottom of th
hours column I do a total. What I want to try and make happen i
when I select a name for filtering I want the total to adjust to
total for just that person I selected. So for example if exce
looked like this

Hours Nam
4 Jos
1 Da
5 Richar
6 Da
7 Jos

23 Tota

Now I select where name = Jose. Below is what I would like excel t
look like afterwards

Hours Nam
4 Jos
7 Jos

11 Tota

Hopefully that isn't too confusing. Any help you can offer is greatl
appreciated

 

[Leo Heuser]

Have a look at the SUBTOTAL function.

 

[Norman Jones]

Hi Maverick,

With a filtered list, use the worksheet Subtotal function - look it up it is
quite versatile.

In your case, replace your sum function with:

=Subtotal(9, A2:A50)

Amend the range A2:A50 to correspond to your data column range.