|
| 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 12th, 2003, 11:24 AM
|
|||
|
|||
auto SUM a FILTERED List
When using the AUTO filter, is there a forumular to SUM the filtered list ( i.e Displayed items) I have used the SUM fuction, this will add up the current filtered list, but then not change when the filter citeria is changed Regards David. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ 
|
|
#2
November 12th, 2003, 11:52 AM
|
|||
|
|||
|
auto SUM a FILTERED List
Use SUBTOTAL(9,range) instead of SUM(range) to total just the selected rows
"davidbrowne17" wrote in message ... When using the AUTO filter, is there a forumular to SUM the filtered list ( i.e Displayed items) I have used the SUM fuction, this will add up the current filtered list, but then not change when the filter citeria is changed Regards David. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
