ExcelBanter - Autofiltering

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Autofiltering (https://www.excelbanter.com/excel-worksheet-functions/164539-autofiltering.html)

Thapelo

Autofiltering

I need to sum only the values that are visible after i have applied the
autofilter.

Dave Peterson

Autofiltering

Look at =subtotal() in xl's help.

Thapelo wrote:

I need to sum only the values that are visible after i have applied the
autofilter.

--

Dave Peterson

Peo Sjoblom

Autofiltering

Look in help for the SUBTOTAL function

=SUBTOTAL(9,your_range)

--

Regards,

Peo Sjoblom

"Thapelo" wrote in message
...
I need to sum only the values that are visible after i have applied the
autofilter.

Thapelo

Autofiltering

Thanks Peo. Solved my problem.

"Peo Sjoblom" wrote:

Look in help for the SUBTOTAL function

=SUBTOTAL(9,your_range)

--

Regards,

Peo Sjoblom

"Thapelo" wrote in message
...
I need to sum only the values that are visible after i have applied the
autofilter.

All times are GMT +1. The time now is 01:51 AM.