|
| 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
May 18th, 2009, 05:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Data continuously when using Filter function - Need Help
Need formula to average column of numbers as is, and as they will be as I
sort by using the Filter. I can do this for total counts using the =Subtotal(9,xx:xx) function but can't figure out how to do it for averages. Much appreciation! -- MGray 
|
|
#2
May 18th, 2009, 05:40 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Averaging Data continuously when using Filter function - Need Help
=Subtotal(9,xx:xx)
Replace the 9 with a 1 to get the average. See help on the SUBTOTAL function for the list of index numbers and their meaning. -- Biff Microsoft Excel MVP "MGray" wrote in message ... Need formula to average column of numbers as is, and as they will be as I sort by using the Filter. I can do this for total counts using the =Subtotal(9,xx:xx) function but can't figure out how to do it for averages. Much appreciation! -- MGray
|
|
#3
May 18th, 2009, 05:44 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Averaging Data continuously when using Filter function - Need Help
Use 1 (to include hidden values) or 101 (to exclude hidden values) instead of
9 to get average... Filtered values are always excluded. Look in Help for subtotal for details. "MGray" wrote: Need formula to average column of numbers as is, and as they will be as I sort by using the Filter. I can do this for total counts using the =Subtotal(9,xx:xx) function but can't figure out how to do it for averages. Much appreciation! -- MGray
|
|
#4
May 18th, 2009, 05:45 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Averaging Data continuously when using Filter function - Need Help
Use the average function number.
=SUBTOTAL(1,xx:xx) Note that function #9 is sum, not count (#2). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "MGray" wrote: Need formula to average column of numbers as is, and as they will be as I sort by using the Filter. I can do this for total counts using the =Subtotal(9,xx:xx) function but can't figure out how to do it for averages. Much appreciation! -- MGray
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
