Do functions work on filtered data in Excel?

  • Thread starter What's up with that?
  • Start date
W

What's up with that?

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.
 
R

RagDyer

Looking up SubTotal() in the Help files will answer your question.
Ever use the Help files?
--


Regards,

RD
 
F

Frank Kabel

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
 
W

What's up with that?

Thanks for your help. I found the online help after specifying the SUBTOTAL
function.
 

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

Cell data entering slow! 0
Calculation Time 2
Filtering data from a non-continuous list 3
Excel --> Word 4
need help on either doing a loop and counting specific values orusing subtotal function 2
Using the IF and Sheets 0
filter result- total row numbers varies 1
Applying function after filter is applied 4

Top