| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to sum a column based on the choice of autofilter?
Hello,
I must sum the columns based on the criteria I choose in the autofilter.Does anyone have a clue how to to this.Hence, I only want to sum the visible cells. I appreciate all respons. Mr.g -up north |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to sum a column based on the choice of autofilter?
Hi
use SUBTOTAL(9,A1:A10) HTH regards Bob C. "Mr.G" wrote: Hello, I must sum the columns based on the criteria I choose in the autofilter.Does anyone have a clue how to to this.Hence, I only want to sum the visible cells. I appreciate all respons. Mr.g -up north |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to sum a column based on the choice of autofilter?
All of the Subtotal functions work on filtered data (visible cells only)
"Mr.G" wrote: Hello, I must sum the columns based on the criteria I choose in the autofilter.Does anyone have a clue how to to this.Hence, I only want to sum the visible cells. I appreciate all respons. Mr.g -up north |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate one column based on the dropdown choice of others | Excel Discussion (Misc queries) | |||
| AutoFilter - get rid of default choice | Excel Worksheet Functions | |||
| Sorting based on Drop Down choice | Excel Discussion (Misc queries) | |||
| Forcing value based on list choice?? | Excel Discussion (Misc queries) | |||
| Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
Linear Mode
