Set up VBA to count and average

[robertmarz]

Basically this is my problem, I would like to count and average data that I have in various fields. What I have is a series of questions that are graded on the following scale 5=100, 4=75, 3=50, 2=25, 1=0. What I would like to do is have VBA or access display how many of each grades are in each catagory, and what each grade averages of the total.

 

[dsi]

Could you provide a little more detail on how your worksheet is configured? Where is the data that needs to be averaged and where do you want the results? DimensionalSolutions@Core.com