Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum only filtered selection
I am dealing with almost 4,000 rows of data. I am auto filtering them and I
would like to be able to sum up only the filtered selection. I can do it manually each time it is filtered, but I was wondering if there was a way to do this automatically. |
#2
|
|||
|
|||
Subtotals doesn't work for you?
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com "pkunAAC" wrote in message ... I am dealing with almost 4,000 rows of data. I am auto filtering them and I would like to be able to sum up only the filtered selection. I can do it manually each time it is filtered, but I was wondering if there was a way to do this automatically. |
#3
|
|||
|
|||
Good afternoon kpunAAC Try this: =SUBTOTAL(9,A1:A4000) HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=386785 |
#4
|
|||
|
|||
You may also want to take a look at the DSUM function. It would allow instant
updating by changing criteria without having to AutoFilter the data at all. HTH |:) "pkunAAC" wrote: I am dealing with almost 4,000 rows of data. I am auto filtering them and I would like to be able to sum up only the filtered selection. I can do it manually each time it is filtered, but I was wondering if there was a way to do this automatically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting within a filtered range | Excel Worksheet Functions | |||
Fit Selection Setting Doesn't Hold | Excel Discussion (Misc queries) | |||
Sumproduct on filtered cells | Excel Worksheet Functions | |||
SELECTION() | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |