| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Select Sum
How do I set criteria to sum only on filtered amounts?
|
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When creating a formula how do you select only visible cells | Excel Discussion (Misc queries) | |||
| Cannot select a chart on an Excel worksheet | Charts and Charting in Excel | |||
| Still can select locked cells in protected sheet | New Users to Excel | |||
| SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
