Auto Filter

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top