Hi Lars, Off the top of my head I can't think of any function that would do exactly that, but depending on what you are trying to achieve, you might be able to get the results you want from a Pivot Table. HTH Chris.
> But data from ars ....Is there a way, I know it is, to make a diagram based > on the > visible rows when autofilter has been selected for some columns. > Now I have the formula Average(A2:A120), if I activate autofilter, maybe only > 22 > rows are returned, so I want average to be calculated only for those 22 rows. > With my formula now the diagram is not changed as the intervall is the same, > in what > way do I have to change the formula to only use visible rows? > > I think someone has the answer. > L ars Pettersson > Vattenfall Business Services Nordic AB > Action Request System Engineer (Tabasco) > S-461 88 Trollhättan > Sweden > > Phone +46 520 888 35 Mobil +46 70 608 99 95 > e-mail: [EMAIL PROTECTED] > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org