There is, I found it, Use Subtotal, =SUBTOTAL(1;$D2:D$68) 1 means average, so if you use autofilter, the average is only calculated for visible rows, very powerful feature. No need to use pivot table, and the diagram is changed when the autofilterselection is changed.
L ars -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Chris Williams Sent: Thursday, August 31, 2006 12:06 PM To: [email protected] Subject: Re: OT: Excel 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
