Is it possible to get an average on the number of times a category appears
within a range.

my categories are
ENC L
NB ENC
V ENC
ALL CL

i want to get the average of the most requested category over 1 month. the
range i am using is would be B6:B36

thank you for your help.