| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter - Add visible cells
Hi,
I have a list containing numerical and text values. I have applied an auto filter and would like to place a formula that adds up these values of the visible cells only. I have used SUBTOTAL(3,A7:A117) for example, but this adds up all the cells, not this filtered visible ones as I would like. Can you help? Thanks Wayne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| Auto Filter and Merged Cells | Excel Worksheet Functions | |||
| No. of rows selected from auto filter not visible on toolbar? | Excel Discussion (Misc queries) | |||
| how do i select all the visible cells only when using auto filter | Excel Discussion (Misc queries) | |||
| How to Sum-If when the cells to sum are Auto-filter visable cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
