EXCEL averages within a filtered list

Fergal · Apr 14, 2004

Please help.

Don Guillett · Apr 14, 2004

Have a look in HELP index for SUBTOTAL

Frank Kabel · Apr 14, 2004

Hi
try
=SUBTOTAL(1,your_range)

Guest · Apr 14, 2004

-----Original Message-----
Hi
try
=SUBTOTAL(1,your_range)

--
Regards
Frank Kabel
Frankfurt, Germany

.Many thanks, it worked a treat.

Guest · Apr 14, 2004

-----Original Message-----
Have a look in HELP index for SUBTOTAL

--
Don Guillett
SalesAid Software
(e-mail address removed)

.Thanks

Don Guillett · Apr 14, 2004

Glad to help

Filters	0	Aug 8, 2021
averaging multiple items from one list	2	May 25, 2012
Need a macro to create a separate document that lists all capitalized words	6	Apr 10, 2022
Help creating a search form in Access XP	0	Mar 4, 2022
Cell data entering slow!	0	Feb 12, 2022
Average For Filtered Cells	1	Apr 12, 2010
Sorting and filtering text	0	Nov 12, 2021
Trying to find additional ranges outside of min, max, and average	2	Aug 17, 2013

Ask a Question