Hi everybody,

I have data such below for a year,
How do i calculate average and stdev from sample1 to sample4 on each date?.
Is there any functions or formulas to automatically calculated it ?
Ex: what is average and stdev from date 3/1/06 ?

I have tried to calculate by subtotals function, but it only can calculate
by colums.

Date sample1 sample2 sample3 sample 4
1/1/06 2 3 1 2
1/1/06 2 1 3 2
1/1/06 3 0 2 3
2/1/06 1 2 1 0
3/1/06 2 1 3 2
3/1/06 0 2 1 3

Thanks,
Charlie