Hey everyone.

I have a sheet full of data, and in Column R3C1 I have the date which
has a filter set on it. In Columns R3C2:R3C17 is various data related
to those dates. On a seperate sheet, I have a running average of each
column. However, when I filter out certain dates, it is still
including them in the average. How can I write it to avoid having the
filtered out information not appear in the averages on the other
sheet??


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=480184