Sorry, long & tedious but HELP, Pleasy !
(I am the only available "expert" at work and this is well beyond me)
Humour me - I'm not quite this sad honest, but let's imagine I wanted to produce a load of graphs charting members' posted bikepics.
I'd score them according to 6 criteria like colour, lawn condition etc (one point for each acceptable answer) and then award a % score (ie total scored divided by possible score).
bikepic scorer by scaredypants, on Flickr
In my image, a single row would be populated for each bike pic with the answer (chosen from a drop-down list of options as shown) displayed as text for use in later charts.
Then some sort of countif type thingy would assign a score for each criterion - the "OK" ones score 1 point and the "No" ones score zero.
However some answers can't be scored ("N/A") and so the possible max score for a pic isn't always 6 (non-applicable criteria must be removed to allow say 5 out of 5 rather than 5 out of 6)
in my sheet, column H would have the actual score (easyish), column I would have max available and I don't know a good way to do that automatically (can "IF" do that sort of thing too ?).
Then J has the % result for each pic (H/I)
I also want to make a chart of average (mean) % score for all pics posted each month, accumulating from now on. (so, Nov | Dec | Jan | etc ) and I don't really know how to do that either.
I reckon I could use a pivot table, group the dates and have the "average" of all scores displayed by month - is that any good ?
or a 
or just STFU and typed nothing.
