Hey everyone,
I've worked out how to to a sum for filtered data (see subject) but I'm wondering how I can do the same but for an average. I would need the filter to change in accordance of what data is filtered.
Any ideas?
Many thanks,
Ben
Hey everyone,
I've worked out how to to a sum for filtered data (see subject) but I'm wondering how I can do the same but for an average. I would need the filter to change in accordance of what data is filtered.
Any ideas?
Many thanks,
Ben
These are the abilities of SUBTOTAL.
Value Explanation
(includes hidden values)
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP
http://www.techonthenet.com/excel/formulas/subtotal.php
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Fotis!
Ben
You are welcome and thanks for the feed back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks