Thank you Jacob. This worked perfectly. The only down fall was that the
dates that accompanied the data also had the time of day in the cells, so I
had to reinput all the dates again without the times. Thanks again.
--
S. Casey


"Jacob Skaria" wrote:

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