Formulas are
Average : =(SUMIF('datalog '!C:C,">1000")/COUNTIF('datalog '!C:C,">1000"))
Mean: =MEDIAN('datalog '!C:C)
Min: =MIN('datalog '!C:C)
Max: =Max('datalog '!C:C)
>4500: =COUNTIF('datalog '!$C:$C,">=4500")
<2500: =COUNTIF('datalog '!$C:$C,"<=2500")

these formulas are working exactly as I would like
The problem I am having is separating the data into date ranges any help would be much appreciated.


Conductivity
Date Average Mean MIN MAX >4500 <2500
Nov 2012
Dec 2012
Jan 2013
Feb 2013
Mar 2013
April 2013
May 2013
Totals: 3355 3459 10 5984 36 5782


Attachment 234510