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
|
|||
|
|||
Select Sum
How do I set criteria to sum only on filtered amounts?
|
#2
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|