Lars,
There is a function in excel (davarage) that will do what you want. Below is a copy of the helptext from excel regarding daverage.
Good Luck
Oscar Herrera :
--------------------------------------------------------------------
Syntax
DAVERAGE(database,field,criteria)
Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such
as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
Criteria is the range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
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
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail. __20060125_______________________This posting was submitted with HTML in it___
