With date in colA the below formula will give you the average of the data in
colB based on the date mentioned in E1 . Please note that this is an array
formula; press CTRL+SHIFT+ENTER to enter the formula. If successful in
'Formula Bar' you can notice the curly braces at both ends like "{=<formula}"

=AVERAGE(IF((A1:A1000=E1),B1:B1000))

If this post helps click Yes
---------------
Jacob Skaria


"S. Casey" wrote:

Can anyone help me with this...

I have a yearly set of hourly data. I want to be able to take daily
averages of the data. I don't really want to have to type in the =average()
and select each days data for the entire year. Using the fill command
doesn't work because it just moves the data set down one cell and averages.
Is there an easy way of doing this that doesn't require hours of work?

--
S. Casey