Need an (average) formula
Closed
Jenn
-
Mar 2, 2011 at 11:37 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2011 at 05:19 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2011 at 05:19 PM
Related:
- Need an (average) formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 3, 2011 at 04:36 AM
Mar 3, 2011 at 04:36 AM
perhaps you need a macro
copy filtered data in another location and find the av erage
RECORD the macro following the steps.
copy filtered data in another location and find the av erage
RECORD the macro following the steps.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 4, 2011 at 05:19 PM
Mar 4, 2011 at 05:19 PM
what version of office you are talking about here. I have not checked in other version but you can use SUBTOTAL function to get the average or other summary info for only visible rows/range in office 2007
for avg that would be
=subtotal(101, F2:F300)
for avg that would be
=subtotal(101, F2:F300)
