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
|