Hi
I would be very grateful if any one could help me. I have several data sets, showing readings from 30 different sites at 30 min intervals for an intire year. i would like to work out daily averages if possible.
Each data set is made up as follows:
Column A is the date in the format d-mmm-yy hh:mm:ss - eg a day will start 01-Jan-10 00:00:00 and end 01-Jan-10 23:30:00
Column's B to AE are 30 different sites, labelled 1-30 and have 2 decimal place readings eg 0.05
is it possible to work out daily averages for each column?
I have tried sumif/countif but found it difficult due to the number of columns.
Many thanks
Rach
Bookmarks