Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel's inbuilt functions on task bar
Hi,
I would like to know if there's a way to access the task Bar functions of Average, Count, Count Nums, Max, Min, Sum, as they respond so well when using Filtering by not including cells that have been "hidden" by the filter. I know the Subtotal function also does this, but I can't seem to get the Subtotal function to respond to Count when the value is text. Rob |
#2
|
|||
|
|||
What "function number" are you using in the Subtotal function?
Don't forget, "2" represents Count, While "3" represents CountA, which is what you would want to use to count text. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Rob" <NA wrote in message ... Hi, I would like to know if there's a way to access the task Bar functions of Average, Count, Count Nums, Max, Min, Sum, as they respond so well when using Filtering by not including cells that have been "hidden" by the filter. I know the Subtotal function also does this, but I can't seem to get the Subtotal function to respond to Count when the value is text. Rob |
#3
|
|||
|
|||
Thanks Ragdyer,
I think I've lost the plot. I had the problem at work and so I posted my problem, but I just tried it at home and it works fine. Must have been a hiccup. I'll have to check it out again at work next week. Rob "Ragdyer" wrote in message ... What "function number" are you using in the Subtotal function? Don't forget, "2" represents Count, While "3" represents CountA, which is what you would want to use to count text. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Rob" <NA wrote in message ... Hi, I would like to know if there's a way to access the task Bar functions of Average, Count, Count Nums, Max, Min, Sum, as they respond so well when using Filtering by not including cells that have been "hidden" by the filter. I know the Subtotal function also does this, but I can't seem to get the Subtotal function to respond to Count when the value is text. Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions |