How do I count the number of day's with entries?
Posted by Jeff on May 21, 2001 8:47 AM
I have numerous days of data on sheet 1:
01-Jan
01-Jan
01-Jan
01-Jan
03-Jan
03-Jan
04-Jan
etc...
On sheet 2 I want to do a running average of entries. How do I have a running total of days with data? I add to this work sheet every day...
Thanks for your help!
Posted by IML on May 21, 2001 10:33 AM
The following should work. It assumes you defined the names of the date column and value column dates and values, respectively.
On the second sheet, list your dates in column A. Put this in column B (assuming your first date is in cell A2) and copy down.
=SUMIF(dates,A3,values)/COUNTIF(dates,A3)
Posted by IML on May 21, 2001 10:34 AM
Oops,...
Assume your first date is in A3
