Hi,

Show us what your data looks like. Second, tell us whether you are running
the percentage by week, month or year - In you discussion you say every week?
Tell us how you know if a particular report is for a specific week, month or
year - is there a date column? Why are there blanks, do you have a list of
reports that should be turned in and then you indicate somehow that it hasn't
been?

--
Thanks,
Shane Devenshire


"magsgundah" wrote:

I have a document that I basically use only to track whether specific weekly
or monthly reports have been submitted. I need to know the percentage of
each report submitted for both the current month and for the year.

I've been having it return percentages by using:
counta(range)/(counta(range) + countblank(range))

I fill down the column of specific reports and get accurate percentages per
report.

Is there a simpler way to do this? Each week I update the range in the
first cell to include the current week and fill down. That works for me, but
my supervisor believes there has to be a more elegant solution. It seems to
me that there should be as well, and If there is, I'd rather use it. If
there isn't, the solution we have works well enough, I guess.