Sum - Filtered values

[Ben_Holmes]

Hi,

Does anyone know if it is possible to sum up filtered columns - allowing only those values which are filtered to be counted within the sum.

I have a large spreadsheet which contains around 40 columns - I want to filter out and sum different criteria within columns within the spreadsheet.

I basically want a cell to tell me the sum of the filtered data. I can then write a macro to sum all of the different variables I am searching for.

Any help would be greatly appreciated

Kind Regards

Ben

 

[Domenic]

You can use the SUBTOTAL function for this...

=SUBTOTAL(9,Range)

Hope this heps!

 

[Ben_Holmes]

That Helps - Thanks a lot Dude!

ray: