Hey,

I'm new to VBA and have hit a roadblock in what im trying to do. I have a column of data containing numbers from 10-360 in intervals of 10. All I need to do is calculate the percentage of each value in the column. For example, I need to count the number of entries of "10" and divide by the total number of entries. I did this using =COUNTIF(A2:A2200,"=10.0")/(2199) and so on but it was very time-intensive. I am looking for an easier way to use COUNTIF in VBA. If anyone can help get me started it would be appreciated. Thanks.