ExcelBanter - How to sum a column based on the choice of autofilter?

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to sum a column based on the choice of autofilter? (https://www.excelbanter.com/excel-programming/320497-how-sum-column-based-choice-autofilter.html)

Mr.G

How to sum a column based on the choice of autofilter?

Hello,
I must sum the columns based on the criteria I choose in
the autofilter.Does anyone have a clue how to to
this.Hence, I only want to sum the visible cells.

I appreciate all respons.
Mr.g
-up north

Robert Christie[_3_]

How to sum a column based on the choice of autofilter?

Hi
use SUBTOTAL(9,A1:A10)

HTH

regards Bob C.

"Mr.G" wrote:

Hello,
I must sum the columns based on the criteria I choose in
the autofilter.Does anyone have a clue how to to
this.Hence, I only want to sum the visible cells.

I appreciate all respons.
Mr.g
-up north

gocush[_29_]

How to sum a column based on the choice of autofilter?

All of the Subtotal functions work on filtered data (visible cells only)

"Mr.G" wrote:

Hello,
I must sum the columns based on the criteria I choose in
the autofilter.Does anyone have a clue how to to
this.Hence, I only want to sum the visible cells.

I appreciate all respons.
Mr.g
-up north

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