Filter Sum question

[TMILJVIPM]

What I need to do is only show the total in the cells I have when I filter a specific item. Here's what I have:

Cell R9 is for total manhours for all projects and the formula I have in it is =sum(R15:R104) so when I filter a certain project number I only want the totals for that specific project to show in cell R9. Now I have multiple cells that total different data but they all have the same formula.

Now 1 total cell which is W9 has formula =average(Y15:Y104).

I hope I explained properly

 

[TMILJVIPM]

Come on guys any help?

 

[TMILJVIPM]

Got it using the search option on the forum.

thanks for all the previous help

 

[Aladin Akyurek]

Got it using the search option on the forum.

thanks for all the previous help

Just in case, for averaging, it's:

=SUBTOTAL(1,Y15:Y104)

 

[TMILJVIPM]

Just in case, for averaging, it's:

=SUBTOTAL(1,Y15:Y104)

yes thats what I found. thanks for all the help