I am really struggling to analyze the attached spread sheet to extract the data I want.
What I would like is a total of all numbers used (1,2,3,4,5,6,7,8,9) to analyze so I can say for example in total we had x amount vehicles inspected under 1 conditions.
I am looking for a formula or pivot table to total the number of 1's,2's, 3's, etc overall over the 2 year period.
Many thanks if anyone has any suggestions!
Bookmarks