Do you want me to start on this formula? If so, do you have suggestions/warnings/likewise formulas to copy from? There is no bug for it (yet), but fdo41214 mentions that AVERAGEIF should b= e in AOOo 3.4. Winfried