|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 27th, 2006, 06:20 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Select Sum
How do I set criteria to sum only on filtered amounts?
|
|
#2
November 27th, 2006, 06:41 PM
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
November 27th, 2006, 09:10 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
