ExcelBanter - Select Sum

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

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Select Sum (https://www.excelbanter.com/setting-up-configuration-excel/120287-select-sum.html)

Lowkey

Select Sum

How do I set criteria to sum only on filtered amounts?

Gord Dibben

Select Sum

=SUBTOTAL(9,A:A) will Sum the visible cells in column A

Gord Dibben MS Excel MVP

On Mon, 27 Nov 2006 10:20:02 -0800, Lowkey
wrote:

How do I set criteria to sum only on filtered amounts?

Gord Dibben

Select Sum

Ammendment..........

Visible due to filtering only.

If you are running 2003 version, to sum visible cells that are due to hiding
rows and/or filtering use

=SUBTOTAL(109,A:A)

Gord

On Mon, 27 Nov 2006 10:41:57 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

=SUBTOTAL(9,A:A) will Sum the visible cells in column A

Gord Dibben MS Excel MVP

On Mon, 27 Nov 2006 10:20:02 -0800, Lowkey
wrote:

How do I set criteria to sum only on filtered amounts?

All times are GMT +1. The time now is 06:25 AM.