Week by week report
Hi All,
I have a spreadsheet which works great but I want to add some additional formulas and need a little help?
There are 2 tabs with this spreadsheet.
The first tab is raw data which shows name, date of audit and audit score. This data contains all audit scores for all members of staff .
The second tab actually shows an average audit score of the data week by week for each person.
Is there a way to add another column next to the percentage to show the number of audits completed? So this would be a count of the entries rather than an average?
So for example, column D would not show the amount of audits completed. Eg Derek Spenser between 30th Sept and 4th Oct = 4
I have attached another example.
Hope this makes sense?
Many thanks
Craig
|