| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional statistics
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Statistics | Excel Discussion (Misc queries) | |||
| Conditional Formatting for Softball Statistics | Excel Discussion (Misc queries) | |||
| Statistics | Excel Discussion (Misc queries) | |||
| Need statistics help! | Excel Worksheet Functions | |||
| p-value, statistics | Excel Discussion (Misc queries) | |||
Hybrid Mode
