Auto Filter

G

Guest

I would like to create a formula that only adds or averages the cells that have been filtered. An example would be when you have a chart and you only plot visible cells.
 
F

Frank Kabel

Hi
use the SUBTOTAL function for this. e.g. summing:
=SUBTOTAL(9,A1:A100)
-----Original Message-----
I would like to create a formula that only adds or
Click to expand...
averages the cells that have been filtered. An example
would be when you have a chart and you only plot visible
cells.
 
G

Guest

Thank you Frank,

This is the first time I have submitted a question on this site and you have
been very helpfull. Your answers to others are always of great use, in my
excel education.
 

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

Auto Filter - Add visible cells 3
Averaging only visible cells 4
Average For Filtered Cells 1
create blank/empty cell - don't want a zero to be plotted in chart 6
Help using autofilter & Sumproduct 4
Auto Filter problem 1
visible cell only 1
formula drag down when using filter in 2007 0

Top