Help with filter analysis please

[xxsalahxx]

Hello
I have a spreadsheet with 4 colums, I have attached filters to each column, what I am trying to do is add up each row of data when filters are on.
Example: I have 169 rows of data showing, i have used a counta (COUNTAD6:D169) on this, however, when i am using the filtering out the data to show what i want the sum is still adding up to 164 and I would like to total only the pieces of data that im filtering out. Is there any possibility i can do this?

Thank you in advance

 

[Richard Schollar]

Hi

Use SUBTOTAL:

=SUBTOTAL(3,D6:D169)

If you want to SUM rather than COUNT then use

=SUBTOTAL(9,D6:D169)

 

[xxsalahxx]

Not getting this to work. I think im not explaining myself properly.

I will post to the Board Html Maker Thank you for your help.