Hello,

I have a sheet that shows data for several months, it has multiple instances
of each day (7/1/2008 may appear in 40 rows) as the data is from different
sources. It has another column that shows the amount of time an even
happened for each date in minutes. I need to filter this information by week
and by the count of times 5 minutes to get the percent of time 5 minutes
this even happened each week. Just to make matters more difficult the data
will be updated each week, thankfully it will be added to the end of the
table so I can just past down the formula.
I'd really appreciate some help with this because a COUNTIF formula keeps
returning errors.
Thank you