count the mean in few date but on de date it has various data
 

Date Time Temperature(C)
23/06/06 1:00:00pm 75
23/06/06 2:00:00pm 76.45
23/06/06 3:00:00pm 68.2
23/06/06 4:00:00pm 74.8
24/06/06 1:00:00pm 76.8
24/06/06 2:00:00pm 74.97
24/06/06 3:00:00pm 78.89
25/06/06 1:00:00pm 78.6
25/06/06 2:00:00pm 75.67
25/06/06 3:00:00pm 75.6
25/06/06 4:00:00pm 74.5
25/06/06 5:00:00pm 76.5
25/06/06 6:00:00pm 74.9

Date Mean of Temparature
23/06/06 ?
24/06/06 ?
25/06/06 ?

i want it like template auto detect n if will count automatically

count the mean in few date but on de date it has various data
 

A17 is cell with date for first mean calculation.Change ranges as required
and copy down.

=IF(COUNTIF($A$2:$A$14,A17)<0,SUMIF($A$2:$A$14,A1 7,$C$2:$C$14)/COUNTIF($A$2:$A$14,A17),"")


Date Time Temperature©
23/06/2006 1:00:00pm 75.00
23/06/2006 2:00:00pm 76.45
23/06/2006 3:00:00pm 68.20
23/06/2006 4:00:00pm 74.80
24/06/2006 1:00:00pm 76.80
24/06/2006 2:00:00pm 74.97
24/06/2006 3:00:00pm 78.89
25/06/2006 1:00:00pm 78.60
25/06/2006 2:00:00pm 75.67
25/06/2006 3:00:00pm 75.60
25/06/2006 4:00:00pm 74.50
25/06/2006 5:00:00pm 76.50
25/06/2006 6:00:00pm 74.90

Date Mean
23/06/2006 73.61 <=== row 17
24/06/2006 76.89
25/06/2006 75.96
26/06/2006

HTH

"LinSeang" wrote:

Date Time Temperature(C)
23/06/06 1:00:00pm 75
23/06/06 2:00:00pm 76.45
23/06/06 3:00:00pm 68.2
23/06/06 4:00:00pm 74.8
24/06/06 1:00:00pm 76.8
24/06/06 2:00:00pm 74.97
24/06/06 3:00:00pm 78.89
25/06/06 1:00:00pm 78.6
25/06/06 2:00:00pm 75.67
25/06/06 3:00:00pm 75.6
25/06/06 4:00:00pm 74.5
25/06/06 5:00:00pm 76.5
25/06/06 6:00:00pm 74.9

Date Mean of Temparature
23/06/06 ?
24/06/06 ?
25/06/06 ?

i want it like template auto detect n if will count automatically