Have you looked into Pivot Tables?
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...le-parameters/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PeSt" wrote in message
...
Hello,

I have a range of conditions in a colums and a range of corresponding
measured values in other
I would like to make automatically basic statistics on the measured
values.

OPERATOR MEASUREMENT
A 10
B 11
A 9
A 8
B 10
A 9
B 12

Now SUM.IF and COUNT.IF exist , but apparently AVERAGE.IF and STDDEV.IF
or MAX.IF and MIN.IF do not exist
Is there a macro of a function that could do this job ?

regards,

Lapeste