Do functions work on filtered data in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I filtered out rows in an Excel sheet and now want to calculate the average
of the filtered numbers. The function still calculates ALL rows, not only
the filtered ones.
 
Looking up SubTotal() in the Help files will answer your question.
Ever use the Help files?
--


Regards,

RD
 
Hi
this is the code for
AVERAGE

See the excel help for the other possible function codes (2-9)

--
Regards
Frank Kabel
Frankfurt, Germany

"What's up with that?" <What's up with [email protected]>
schrieb im Newsbeitrag
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hidden rows problem 7
Intercept and Slope of visible rows, please. 0
Applying function after filter is applied 4
VBA to Filter on variable column 5
Referncing Rows of Filtered Data 8
Macro to copy value in field and insert it into filter 2
Calculation Time 2
reference cell from advanced filter 3

Back
Top